Index Rebuild vs Reorganize: The transaction log edition

Recently a friend and fellow PFE Dave Levy (Twitter/Blog) and I were discussing a question someone posted in a forum. The question was in regards to database mirroring latency when a reorganization occurs. Dave mentioned that he has seen in the past that switching from performing a reorganization to a rebuild resulted in better throughput…

8

Optimizing ad-hoc workloads

Today’s tip isn’t necessarily low-level, but it is a setting that you should consider turning on for your SQL Server instances (especially if you’ve got vendor applications that generate TSQL statements on the fly).  The setting,  “optimize for ad-hoc workloads”, is configured using sp_configure and when enabled will generate a very small execution plan stub…

2