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
| 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. |
http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=322
miscellaneous °-°
-
-
backup «best practices» books «cumulative update» datetime dmv faq humor index indexoptimize integrity links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack t-sql «technical note» tools troubleshooting whitepapers
XML FeedsSchlagwort-Wolke
backup «best practices» books «case study» ctp «cumulative update» datetime dmv ebook exams faq humor index indexoptimize integrity kb learning links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reports reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql 2008» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» sqlsrv ssms ssmstoolspack t-sql «technical note» tools training troubleshooting whitepapers