Home Forums Article Discussions Article Discussions by Author Discuss content posted by derekr 43208 List all tables without LOB columns RE: List all tables without LOB columns
SQLSACT
SSC-Insane
Points: 21838
More actions
August 30, 2011 at 6:52 am
#1374939
A Clustered Index whose base table that has any column that is LOB cannot be rebuilt online.
A Non clustered index whose base table has any non key LOB columns participating in the index cannot be rebuilt online.