You work as the database administrator at Domain.com. You are responsible for writing procedure documents for the company. All servers on the Domain.com network run Windows Server 2003. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 was recently upgraded from SQL Server 2000 to SQL Server 2005.
You need to review and update the procedure for reducing fragmentation on indexes. The current procedure document recommends the use of the DBCC SHOWCONTIG and DBCC INDEXDEFRAG statements. You need to alter the procedure document to recommend the use of commands and statements that will be supported in future versions of SQL Server.
What should you do?