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

No feedback yet
Leave a comment

Your email address will not be revealed on this site.
PoorExcellent
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case sensitive)
Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case sensitive)