[dba-SQLServer] Question about the transaction log

Arthur Fuller fuller.artful at gmail.com
Fri Oct 3 12:12:43 CDT 2008


Suppose that I issue an ALTER INDEX ALL REBUILD command. Does stuff get
written to the transaction log? If so, can I turn that off, and then turn it
back on after I have rebuilt the indexes?

I looked in Paul Nielsen's SQL Bible and found nothing relevant. Tried BOL
as well and nothing emerged.

Arthur



More information about the dba-SQLServer mailing list