DROP TABLE IF EXISTS dbo.t;
CREATE TABLE dbo.t
(
id int NOT NULL
IDENTITY(1,1)
, someData varchar(8000)
, INDEX tcx CLUSTERED (id)
);
GO
;WITH src AS
(
SELECT *
FROM (VALUES (0), (1), (2), (3), (4), (5), (6), (7), (8), (9))v(n)
)
INSERT INTO dbo.t (someData)
SELECT CONVERT(varchar(8000), CRYPT_GEN_RANDOM(8000), 0)
FROM src s1
CROSS JOIN src s2
CROSS JOIN src s3;
GO
SET STATISTICS IO ON;
SELECT t.id --read only the ID column, which is the clustering key
FROM dbo.t t;
