Tom.Thomson (2/3/2009)
It seems expensive to me, re-ednabling the clustered index implies rebuilding every index on the table.
With SQL Server 2005 and greater, rebuilding the clustered index does not force a rebuild of all NC indexes.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs