What should you do?

You discover that all indexes of the Sales table on your SQL Server 2005 database server are heavily fragmented. You need to decrease the fragmentation of all indexes of the Sales table to a minimum, while keeping the Sales table available to all users. What should you do?

You discover that all indexes of the Sales table on your SQL Server 2005 database server are heavily fragmented. You need to decrease the fragmentation of all indexes of the Sales table to a minimum, while keeping the Sales table available to all users. What should you do?

A.
Defragment the disk that contains the Sales table.

B.
Execute the following statement.USE master;GODBCC CLEANTABLE (‘DB1′,’sales’);GO

C.
Execute the following statement.USE DB1;GOALTER INDEX ALL ON sales REORGANIZE WITH
(LOB_COMPACTION = ON);GO

D.
Execute the following statement.USE DB1;GOALTER INDEX ALL ON sales REBUILD;GO



Leave a Reply 0

Your email address will not be published. Required fields are marked *