After answering over 2000 performance emails, I saw that many users do not know how to send execution plan in email. Here is the easy way to do it.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
Do you use the actual or the estimated execution plan? A candidate asked me this in an interview. I always use the actual plan, and here is why.
SQL SERVER 2016 – Comparing Execution Plans
A query runs fine in test but slow in production? SQL Server 2016 tools add a way of comparing execution plans so you can find what changed.
Plan Guides: Fixing a Query You Cannot Change
Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.
Top N per Group: Three Ways and Which Is Fastest
Compare top N per group with ROW_NUMBER, APPLY and a correlated subquery, define tie behavior, and measure plans with a supporting index.
CE Feedback for Expressions in SQL Server 2025
Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.