DECLARE @mod INT = 1000,
@start_time DATETIME,
@end_time DATETIME;

DROP TABLE IF EXISTS dbo.STG_1048576;
CREATE TABLE dbo.STG_1048576 (ID BIGINT NOT NULL);
INSERT INTO dbo.STG_1048576
SELECT TOP (1048576) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) RN
FROM master..spt_values t1
CROSS JOIN master..spt_values t2;

DROP TABLE IF EXISTS dbo.CCI_BIGINT;
CREATE TABLE dbo.CCI_BIGINT (ID BIGINT NOT NULL, INDEX CCI CLUSTERED COLUMNSTORE);

DROP TABLE IF EXISTS #RES;
CREATE TABLE #RES (MOD_NUM INT NOT NULL, TIME_IN_MS INT NOT NULL);


WHILE @mod <= 20000
BEGIN
    TRUNCATE TABLE dbo.CCI_BIGINT;

    SET @start_time = GETDATE();

    INSERT INTO dbo.CCI_BIGINT WITH (TABLOCK)
    SELECT ID % @mod
    FROM dbo.STG_1048576
    OPTION (MAXDOP 1);

    SET @end_time = GETDATE();

    INSERT INTO #RES VALUES (@mod, DATEDIFF(MILLISECOND, @start_time, @end_time));
    SET @mod = @mod + 1000;

END;

SELECT * FROM #RES