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.