Guest User

Untitled

a guest
Apr 14th, 2014
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.42 KB | None | 0 0
  1. USE tempdb
  2. CREATE TABLE T (Col1 INT NOT NULL, Col2 INT NOT NULL)
  3. CREATE UNIQUE CLUSTERED INDEX ci ON T(Col1)
  4. CREATE NONCLUSTERED INDEX nci ON T(Col2)
  5.  
  6. INSERT INTO T (Col1, Col2)
  7. VALUES  (0, -- Col1 - int
  8.          0  -- Col2 - int
  9.          )
  10. INSERT INTO T (Col1, Col2)
  11. VALUES  (1, -- Col1 - int
  12.          0  -- Col2 - int
  13.          )
  14.  
  15. DBCC IND(tempdb, 'T', 1)
  16.  
  17. DBCC TRACEON (3604);
  18. DBCC PAGE ('tempdb', 1, 1100009, 3);
Advertisement
Add Comment
Please, Sign In to add comment