This week I came across what could quite possibly be, the best SQL Server index defrag script I have seen.
This little beauty is fully customisable and is freely available courtesy of Michelle Ufford (aka SQL Fool) on her blog SQLFool.com
As you know, it is just not practical to use a SQL Server Maintenance Plan to manage the index optimisation of an enterprise scale database. This then leads all good DBA’s to create their own custom built script which is all well and good but why re-invent the wheel, right!
Every SQL Server DBA should have a custom Index Defrag Script in their toolbox and this one has earned a well deserved place in the performance tuning area of this site.
Get your hands on the script here at SQLFool.com
Do you have any scripts or tools that have made your life as a DBA easier? Let me know and I will add them to the site.