Tim Chapman

SQL Server Dedicated Support Engineer (PFE)
Posts
  • Tim Chapman

    Index Rebuild vs Reorganize: The transaction log edition

    • 5 Comments
    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...
  • Tim Chapman

    Optimizing ad-hoc workloads

    • 1 Comments
    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...
Page 1 of 1 (2 items)