What is a WorkTable in SQL Server? Run a simple CROSS JOIN with STATISTICS IO on and you will see one. Here is what it is and why SQL Server creates it.
SQL SERVER – When to Turn On Optimize for Ad Hoc Workloads?
A true story from a recent health check, with two instances on one server, shows when you should turn on Optimize for Ad Hoc Workloads.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to clear plan cache with Database Scoped Configuration? In SQL Server 2016 and later, one T-SQL command clears the plans for one database.
What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan? – Interview Question of the Week #122
Question: What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan?
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115
Want to see How Many Rows Each Query Returned along with its execution plan? Here is a query for it, and why reads and worker time matter more.
How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098
How do you find the longest running query with execution plan in SQL Server? Here is a quick DMV query that returns the top 10 along with their plans.
Parameter Sensitive Plans: Reading Query Variants in Query Store
Inspect query variants and dispatcher plans in Query Store, compare skewed parameter values, and read the boundaries selecting each plan.