April 18, 2009 | SQL Server

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 or between Kirby and Quigley.  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.)

1 comment on this post

    • tosc - August 8, 2009, 12:03 AM

      Yes, both of them are helpful. Remember, Ola have some problems with his blog platform, so I think it`s better to point to http://ola.hallengren.com/ 🙂

Comments are closed.