The September edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column.

This month's topics are:

  • Online index operations logging changes in SQL Server 2008
  • Is that transaction contained in my full backup?
  • ALTER INDEX … REBUILD vs. ALTER INDEX … REGORGANIZE
  • Avoiding regular log file shrinking

Check it out at http://technet.microsoft.com/en-us/magazine/hh395481.aspx.