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.
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.
Spotting tempdb Contention
Spot tempdb contention through PAGELATCH waits and allocation pages, then review file layout and current server settings before changing files.
SQL SERVER – CE – 3 Links to Performance Tuning Compact Edition
Three Microsoft articles on performance tuning Compact Edition, including database design and query performance, the base of my SQL CE webcast.