Compare catch-all queries with recompilation, parameterized dynamic SQL, and SQL Server 2025 optional parameter plan optimization.
SQL SERVER – Cleanup Plan Cache For a Single Database
After tuning a client’s database, a DBA rushed to run DBCC FREEPROCCACHE for the whole server. Here is how to clean up the plan cache for a single database instead.
SQL SERVER – How to Optimize Your Server Performance by Reducing IO Waits?
SQL Server tuning is mostly balancing CPU, memory and IO. In this post I show how to reduce IO waits for your queries and optimize your server performance.
Finding the Plan That Changed: Query Store Plan History
Read Query Store plan history, compare duration by interval, find plan changes, and review a temporary force with an exit plan.
The Ascending Key Problem: Estimates for Today’s New Rows
Diagnose ascending key estimates with histogram boundaries, modification counts, and controlled comparisons before updating statistics.
Diagnosing Blocking Chains With sys.dm_exec_requests
Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.
Columnstore Rowgroup Health: Finding Small and Open Rowgroups
Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.