March 23, 2012 at 1:59 am
Hi Guys
When using a Maintenance Plan to rebuild indexes ONLINE in SQL 2005
How does it handle LOB's.
Does it fail when it finds an Index with a LOB column or does it just leave it and continue?
Thanks
March 23, 2012 at 10:02 am
From Guidelines for Performing Online Index Operations:
- Clustered indexes must be created, rebuilt, or dropped offline when the underlying table contains large object (LOB) data types: image, ntext, text, varchar(max), nvarchar(max), varbinary(max), and xml.
- Nonunique nonclustered indexes can be created online when the table contains LOB data types but none of these columns are used in the index definition as either key or nonkey (included) columns. Nonclustered indexes defined with LOB data type columns must be created or rebuilt offline.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 23, 2012 at 10:04 am
The maintenance plan will fail when it hits one of those indexes with an LOB. We have had to create custom plans for those types of indexes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 23, 2012 at 10:23 am
Instead of Maintenance Plans, check out Ola Hallengren's SQL Server Index and Statistics Maintenance. I started using it about a year ago and have never looked back at MPs.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 23, 2012 at 10:38 am
Another option (I use this one) is by Michelle Ufford, here[/url].
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply