Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
Query Store Capture Modes: ALL, AUTO and CUSTOM
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.