SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.Demo
(
    c1 integer NOT NULL,
    c2 integer NOT NULL,
    c3 integer NOT NULL
);

INSERT TOP (4 * 1000 * 1000) dbo.Demo
    WITH (TABLOCKX)
    (c1, c2, c3)
SELECT
    ABS(CHECKSUM(NEWID())),
    ABS(CHECKSUM(NEWID())),
    ABS(CHECKSUM(NEWID()))
FROM master.dbo.spt_values AS SV1
CROSS JOIN master.dbo.spt_values AS SV2;
4000000 rows affected

CREATE CLUSTERED INDEX ccsi 
ON dbo.Demo (c1, c2);
CREATE NONCLUSTERED COLUMNSTORE INDEX nccsi
ON dbo.Demo (c1, c2)
WITH (MAXDOP = 1);
SELECT
    CSS.column_id,
    column_name = C.[name],
    rowgroup_id = CSS.segment_id,
    CSS.min_data_id,
    CSS.max_data_id,
    CSS.row_count
FROM sys.partitions AS P
JOIN sys.column_store_segments AS CSS
    ON CSS.hobt_id = P.hobt_id
JOIN sys.indexes AS I
    ON I.[object_id] = P.[object_id]
    AND I.index_id = P.index_id
JOIN sys.index_columns AS IC
    ON IC.[object_id] = I.[object_id]
    AND IC.index_id = I.index_id
    AND IC.index_column_id = CSS.column_id
JOIN sys.columns AS C
    ON C.[object_id] = P.[object_id]
    AND C.column_id = IC.column_id
WHERE
    P.[object_id] = OBJECT_ID(N'dbo.Demo', N'U')
ORDER BY
    C.column_id,
    CSS.segment_id;


column_id
column_name
rowgroup_id
min_data_id
max_data_id
row_count


1
c1
0
566
563406074
1048576

1
c1
1
563406557
1125911615
1048576

1
c1
2
1125911981
1689016733
1048576

1
c1
3
1689017107
2147483007
854272

2
c2
0
4506
2147483562
1048576

2
c2
1
207
2147483256
1048576

2
c2
2
2252
2147481957
1048576

2
c2
3
1468
2147483545
854272

column_id	column_name	rowgroup_id	min_data_id	max_data_id	row_count
1	c1	0	566	563406074	1048576
1	c1	1	563406557	1125911615	1048576
1	c1	2	1125911981	1689016733	1048576
1	c1	3	1689017107	2147483007	854272
2	c2	0	4506	2147483562	1048576
2	c2	1	207	2147483256	1048576
2	c2	2	2252	2147481957	1048576
2	c2	3	1468	2147483545	854272