Courtesy of the SQL Fool an awesome script to defragment the SQL Server indexes. This is a maintenance script and can be useful for improving your overall SQL Server performance issues.
SQL utility and maintenance scripts can be applicable for both Insight and TCX installations running SQL Server.
So does index defragmentation matter? From Microsoft SQL Server 2000 Index Defragmentation Best Practices:
"The workload performance increase realized in the small-scale environment ranged from 60 percent at the low level of fragmentation to more than 460 percent at the highest level of fragmentation. The workload performance increased realized for the large-scale environment ranged from 13 percent at the low fragmentation level to 40 percent at the medium fragmentation level."So how to use this defragmentation script?