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.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.







