Task 1.4.3 Repair Corrupt Indexes SQL

Purpose: Reorganize indexes on tables to improve performance.

A SQL Server database automatically maintains indexes whenever insert, update, or delete operations are made to the underlying data.

Over time these modifications can cause the information in the index to become corrupt.  This can degrade query performance and cause your application to respond slowly or erratically. You can remedy index fragmentation by reorganizing or rebuilding an index.

To reorganize all indexes in a table using SQL Server Management Studio (SSMS):

1. Backup the tables being reorganized.

2. In Object Explorer, Expand the database that contains the table on which you want to reorganize the indexes.

3. Expand the Tables folder.

4. Expand the table on which you want to reorganize the indexes.

5. Right-click the Indexes folder and select Reorganize All.

6. In the Reorganize Indexes dialog box, verify that the correct indexes are in the Indexes to be reorganized. To remove an index from the Indexes to be reorganized grid, select the index and then press the Delete key.

7. Select the Compact large object column data check box to specify that all pages that contain large object (LOB) data are also compacted.

8. Click OK.