SQL Server 2022 Finally Fixed a SQL Server 2008 Query ...
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan […]
Execution plans
Updated Training Modules for SQL Server 2019 & 2022
At the PASS Summit this month, I presented a 1-day workshop called T-SQL Tuning for SQL Server 2019 […]
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL […]
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT […]
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution […]
Plansplaining, part 20. SQL Graph (part 1)
The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral.
Explore Natively Compiled SQL Server Stored Procedure Execution Plans
The post Explore Natively Compiled SQL Server Stored Procedure Execution Plans appeared first on SQLServerCentral.
What’s Faster: IN or OR? Columnstore Edition
Pinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would […]