Our company is so excited to finally get 2008 SQL Enterprise with the hope of getting our re-indexing online and preventing down time during index rebuilds. However, during testing, I realized that there are limitations to the online re-indexing feature,
namely where the following datatypes exist in the table: "text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type". Is there any work-around this, besides the REORGANIZE feature? Our main tables - over 5 million records
each - have clustered indexes and XML columns (though non-indexed) within the table.
View Complete Post