CREATE DATABASE temporal3g ON (NAME = 'temporal3g', FILENAME = 'S:\MSSQL\DIXNEUF\temporal3g.mdf'),
FILEGROUP Group3  (NAME = 'Group3', FILENAME = 'S:\MSSQL\DIXNEUF\temporal3g_group3.ndf')
LOG ON (NAME = 'temporal3g_log', FILENAME = 'S:\MSSQL\DIXNEUF\temporal3g.ldf')
go
USE temporal3g
go
CREATE TABLE temporalmain (
    id      int     NOT NULL,
    name    sysname NOT NULL,
    uppername AS upper(name),
    start   datetime2(3) GENERATED ALWAYS AS ROW START NOT NULL,
    stop    datetime2(3) GENERATED ALWAYS AS ROW END   NOT NULL,
    PERIOD FOR SYSTEM_TIME (start, stop),
    CONSTRAINT pk_temporalmain PRIMARY KEY (id)
)
WITH (SYSTEM_VERSIONING=ON (HISTORY_TABLE= dbo.temporalhist))
go
INSERT temporalmain(id, name)
   SELECT object_id, name
   FROM   sys.objects
go
WAITFOR DELAY '00:00:01'
go
UPDATE temporalmain
SET    name = reverse(name)
go
CREATE UNIQUE CLUSTERED INDEX pk_temporalmain ON temporalmain(id) WITH (DROP_EXISTING = ON) ON Group3 
go
CREATE CLUSTERED INDEX ix_temporalhist ON temporalhist(stop, start) WITH (DROP_EXISTING = ON) ON Group3
go