An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.
One Default Row per Customer With a Filtered Unique Index
Two browser tabs, two default addresses. Here is how a filtered unique index keeps the rule in the database and how to switch defaults safely.
Splitting OR Conditions Into UNION ALL for Index Seeks
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.