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.)

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

1 Response

  1. tosc says:

    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/ 🙂
    CU
    tosc