SQL Q & A: Removing Index Fragmentation, Synchronizing vs. Synchronized, and More

June 2009

Paul Randal answers your SQL questions: How does removing index fragmentation affect statistics? Does data compression interfere with backups? Can you explain database mirroring states? And more!