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
| Print article | This entry was posted by tosc on 2009-04-20 at 08:23:01 . Follow any responses to this post through RSS 2.0. |
-
-
backup «best practices» books bug ctp «cumulative update» demo dmv ebook humor index indexoptimize integrity kbfix maintenance «ms sql server 2008» performance php reviews serverproperty «service pack» «service pack 2» «service pack 3» «service packs» sharepoint «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack t-sql «technical note» tempdb tools whitepapers
Tag cloud
administration backup «best practices» books bug ctp «cumulative update» demo dmv ebook humor index indexoptimize integrity kbfix links maintenance «ms sql server 2008» pass performance php profiler reviews «ross mistry» serverproperty «service pack» «service pack 2» «service pack 3» «service packs» sharepoint «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» sysadmin t-sql technet «technical note» tempdb tools «trace flag» version whitepapers