8RQGFDfH

1USE Db1
2GO
3
4DROP TABLE IF EXISTS [dbo].[TESTTABLE]
5GO
6
7-- insert 400 million dummy records 
8SELECT 
9    TOP 400000000 IDENTITY(int,1,1) AS Number 
10INTO 
11    [dbo].[TESTTABLE]
12FROM 
13    sys.columns s1       
14CROSS JOIN 
15    sys.columns s2 
16CROSS JOIN 
17    sys.columns s3 
18
19
20USE Db2
21GO
22
23DROP TABLE IF EXISTS [dbo].[TESTTABLE]
24GO
25
26-- create table with a timestamp/rowversion column
27CREATE TABLE [dbo].[TESTTABLE](
28    [StageTimestamp] [timestamp] NOT NULL,
29    [SomeNumber] [int] NOT NULL
30)
31
32GO
33
34-- insert 400 million records into the table
35INSERT INTO
36    [dbo].[TESTTABLE] WITH (TABLOCK) (SomeNumber)
37SELECT
38    Number
39FROM
40    [db1].[dbo].[TESTTABLE]
41GO