Which of the following is used to determine the fragmentation for tables and indexes ?
A. DBCC SHOWCONTIG
B. DBCC CHECKDB
C. DBCC CHECKCATALOG
D. None of the mentioned
Answer:A
Which of the following is used to determine the fragmentation for tables and indexes ?
A. DBCC SHOWCONTIG B. DBCC CHECKDB C. DBCC CHECKCATALOG D. None of the mentioned
Explanation:In SQL Server 2005 DBCC SHOWCONTIG remains a viable short term option to determine the database fragmentation.