SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Ola Hallengren Ola, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts:

  • Support for Xml indexes
  • Support for Spatial indexes
  • Support for indexed views
  • An index that contains a column with a large CLR type cannot be rebuilt online. The new version has correct handling of this
  • An index that has ALLOW_PAGE_LOCKS set to OFF cannot be reorganized. The new version is doing a rebuild instead of a reorganize if page locking is disabled

CU
tosc