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