Test splitting OR conditions into disjoint UNION ALL branches, preserve NULL behavior and row identity, and compare actual index access.
tempdb-Heavy Queries: Finding Them in Query Store
The tempdb spike is over before you log in. Query Store remembers who caused it, and here is how to ask.
TOP N Sort: Why a Small TOP Still Reads the Whole Table
Explain TOP N Sort, compare an indexed ordered access path, and align filter and sort keys before adding indexes for frequent requests.
SQL SERVER – Measure Index Performance
I measure index performance against the same workload before and after a change. A customer wanted to assess a new index.
SQL SERVER – List of Trace Events
sys.trace_events lists available SQL trace events rather than only default-trace collection. Readers asked after my creation-date article.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
CPU Scheduler Waiting on Disk: Read Pending Disk IO
A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.







