« Troubleshooting Performance Problems in SQL Server 2008
Whitepaper-Links collection page for SQL Server »

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


Qui tacet, consentire videtur

backup, index, integrity, maintenance
SQL Server
 Print article This entry was posted by Torsten Schuessler on 2009-04-20 at 08:23:01 . Follow any responses to this post through RSS 2.0.
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)

Tag cloud

administration backup «best practices» books bug ctp «cumulative update» datetime denali dmv ebook humor index indexoptimize integrity kbfix links loginproperty maintenance «ms sql server 2008» performance php «reporting services» reviews «ross mistry» rtm serverproperty «service pack» «service pack 3» «service packs» sharepoint sp_msforeachdb «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql technet «technical note» tempdb tools troubleshooting version whitepapers