Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.
Reading DBCC SHOW_STATISTICS Step by Step
Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.
Why the Same Query Is Fast Then Suddenly Slow
Recognize parameter sniffing by comparing compiled values, data distribution, and reused plans, then test a remedy with its tradeoffs.
Real-Time Operational Analytics With a Filtered Columnstore Index
Build real-time operational analytics with a filtered columnstore index, inspect batch-mode plans and rowgroups, and measure write costs.
UNION vs UNION ALL: Reading the Operators Each One Adds to a Plan
Compare UNION vs UNION ALL through actual plans, duplicate-removal operators, memory grants and reads, then prove when branches cannot overlap.
Bitmap Filters in Parallel Hash Joins: Reading Them in a Plan
Read bitmap filters in parallel hash join plans, compare fact scan output, and distinguish early row rejection from guaranteed savings.
OPTION (FORCE ORDER): When a Join Order Hint Helps and Hurts
Test OPTION (FORCE ORDER) against real join plans, see when fixed table order helps or hurts, and apply a reversible Query Store hint.