Advertisement
SQL_Kiwi

Untitled

Jul 30th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.80 KB | None | 0 0
  1. DROP TABLE IF EXISTS dbo.CCI;
  2. CREATE TABLE dbo.CCI (ID BIGINT NOT NULL, INDEX ICCI CLUSTERED COLUMNSTORE);
  3.  
  4. INSERT INTO dbo.CCI WITH (TABLOCKX)
  5. SELECT TOP (1048576)
  6.     ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) RN
  7. FROM master..spt_values t1
  8. CROSS JOIN master..spt_values t2
  9. OPTION (MAXDOP 1);
  10.  
  11. DBCC TRACEON (3604);
  12.  
  13. DECLARE
  14.     @DBID SMALLINT = DB_ID(),
  15.     @partition_id BIGINT =
  16.     (
  17.         SELECT
  18.             CSS.[partition_id]
  19.         FROM sys.partitions AS P
  20.         JOIN sys.column_store_segments AS CSS
  21.             ON CSS.[partition_id] = P.[partition_id]
  22.         WHERE
  23.             P.[object_id] = OBJECT_ID(N'dbo.CCI', N'U')
  24.     )
  25.  
  26. DBCC CSINDEX
  27. (
  28.     @DBID,
  29.     @partition_id,
  30.     2,  -- column id
  31.     0,  -- segment_id
  32.     1,  -- 1 = segment
  33.     0   -- print option
  34. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement