Monthly Archives: July 2012

DBCC IND and DBCC PAGE

DBCC IND – use to lookup what pages are allocated to an object Syntax: DBCC IND ( database_name, table_name, index_id ) NOTE: there must be records in the table before this will return a result set. NULL values in the … Continue reading

Posted in Troubleshooting | Comments Off on DBCC IND and DBCC PAGE