Another index maintenance script update
As I have blogged about before, I use index maintenance scripts from two very capable contributors: Ola Hallengren and Michelle Ufford (a.k.a. @sqlfool). Sometimes when I talk about one or the other, I feel like I am choosing between mom and dad. The reality is that I use both sets of scripts in different situations, and don't really favor one over the other… though I still feel when I have an update about one of them that I am encouraging some kind of competition. Nothing could be further from the truth.
That said, yesterday Ola alerted me that he made some updates to his maintenance scripts, namely:
- BEGIN / END around procedure bodies (THANK YOU!)
- Support for XML and spatial indexes
- Support for indexed views
- Proper handling of CLR/online and ALLOW_PAGE_LOCKS OFF scenarios
You can see the comments on the new release here.
(I found and corrected a couple of issues in Michelle's scripts that she is promising will be fixed in the next version; most importantly, the current version will treat all indexes as containing LOB after it has encountered a single index containing LOB.)