THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at since 2006, focusing on manageability, performance, and new features, and also blogs at and; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

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

Published Saturday, April 18, 2009 4:17 PM by AaronBertrand
Filed under:



Aaron Bertrand said:

I have blogged about both of them before ( here and here ), but I can never say enough about how helpful

June 19, 2009 2:26 PM

tosc said:

Yes, both of them are helpful. Remember, Ola have some problems with his blog platform, so I think it`s better to point to :-)



August 7, 2009 5:03 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog



Privacy Statement