Articles tagged

31 July 2009
31 July 2009

Defragmenting Indexes in SQL Server 2005 and 2008

Rob Sheldon tackles the subject of Index Defragmentation in SQL Server 2005 and 2008, using the sys.dm_db_index_physical_stats system function. He shows how to analyze indexes and, if necessary, how to go about  reorganizing or rebuilding indexes. He makes the point that, by analyzing indexes effectively, you can save a lot of unnecessary  rebuilding of indexes.… Read more