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

    The Pains of Filtered Indexes

    • 6 Comments
    In a previous post I briefly went over how useful filtered indexes can be. Filtered indexes are a great feature that have numerous uses. However, like almost everything in computing, there are trade-offs, and filtered indexes are no exception. The challenge...
  • Tim Chapman

    Visualizing Index Fragmenation

    • 2 Comments
    We all probably realize that fragmentation can be a performance hindrance, especially for scanning operations. But, what does fragmentation really mean? What does it look like? I've been doing a lot of training for customers lately in terms of fragmentation...
  • Tim Chapman

    The Joys of Filtered Indexes

    • 5 Comments
    A filtered index, introduced in SQL Server 2008, is a non-clustered index that contains only a subset of the number of rows contained in a table. Because there is a 1:1 ratio between the number of rows in a table and the number of rows in a regular non...
  • 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...
  • Tim Chapman

    How to Parse DBCC MEMORYSTATUS via Powershell

    • 0 Comments
    SQL Server has many ways to dig deep into diagnosing memory related problems. Today it is common to use Dynamic Management Objects (views/functions) to expose a large portion of this information. However, some useful data isn't consumable by DMVs, so...
Page 1 of 1 (6 items)