Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE tempdb
- CREATE TABLE T (Col1 INT NOT NULL, Col2 INT NOT NULL)
- CREATE UNIQUE CLUSTERED INDEX ci ON T(Col1)
- CREATE NONCLUSTERED INDEX nci ON T(Col2)
- INSERT INTO T (Col1, Col2)
- VALUES (0, -- Col1 - int
- 0 -- Col2 - int
- )
- INSERT INTO T (Col1, Col2)
- VALUES (1, -- Col1 - int
- 0 -- Col2 - int
- )
- DBCC IND(tempdb, 'T', 1)
- DBCC TRACEON (3604);
- DBCC PAGE ('tempdb', 1, 1100009, 3);
Advertisement
Add Comment
Please, Sign In to add comment