Query Plan Pop Quiz Answers 2 and 3: I’ve Got ...
In the Query Plan Pop Quiz, questions 2 and 3 asked you about what the sizes of arrows […]
Execution plans
Query Plans Pop Quiz Answer #1: Costs are Garbage.
In last week’s Query Plans Pop Quiz, the first question was, someone hands you these two queries and […]
Query Plans Pop Quiz: Three Simple Questions
Question 1: Pick the Problematic Plan: someone hands you a pair of queries, and you get the estimated […]
Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server 2022 has lot of improved and advanced features compared to its predecessor versions. This includes new […]
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 […]
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.