Inspect the SQL Server plan cache, identify single-use plans and memory use, and understand what optimize for ad hoc workloads changes.
Checking Data Compression Settings on Every Table and Index
A table is not simply compressed or not. Here is how to read the setting for each index and partition, and the mistake that leaves indexes full size.
Temp Table Caching: Why Some Temp Tables Get Reused
Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.
SQL SERVER – How to Ignore Columnstore Index Usage in Query
A reader’s query ran slower after adding a nonclustered columnstore index. Here is how to ignore columnstore index usage for just that one query.
SQL SERVER – Fundamentals of Columnstore Index
Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.
SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution
What does the TRACEWRITE wait type mean, and how do you resolve it? A DBA saw it as the top wait on his system, so here is a quick explanation.
POC Index: Supporting Window Functions Without a Sort
Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.