sql2008-- index operation
Posted on 2014-01-26
I read one of teh document for index operation in sql server, I don't understands below point by Mcsft, does it means here when I run index operation with begin or end transaction, thsi is call explicit transaction ?
4. Do not run the online index operation in an explicit transaction. The log will not be truncated until the explicit transaction ends.
How about if I run it below?
'ALTER INDEX ALL ON ? REBUILD WITH (SORT_IN_TEMPDB = ON)'
-- force a checkpoint to reduce transaction log space used by the rebuild