Microsoft SQL Server 2000 Index Defragmentation Best Practices

Author: Mike Ruthruff February 2003 Summary As Microsoft SQL Server 2000 maintains indexes to reflect updates to their underlying tables, these indexes can become fragmented. Depending on workload characteristics, this fragmentation can adversely affect .

technet.microsoft.com