Blog

SQL Server Maintenance: Index Fragmentation, Rebuild vs Reorganize, Statistics Updates, DBCC CHECKDB and Ola Hallengren

In index maintenance what matters is page density and cost, not fragmentation: on a 39% fragmented index REORGANIZE produced 3.6 times and an ONLINE rebuild 7 times the log of an offline REBUILD, and UPDATE STATISTICS after a rebuild replaced full-scan statistics with an 11% sample. Repairing a corrupt nonclustered index with DBCC CHECKDB without data loss, and Ola Hallengren's IndexOptimize, DatabaseIntegrityCheck and DatabaseBackup procedures.