SQL Performance Archives - SQLPerformance.com

The Lock Escalation Threshold – Part 3

In the third part of his series on lock escalation, Paul White discusses how long SQL Server holds locks and why.

Paul White ◆ October 20, 2022

0

The Lock Escalation Threshold – Part 2

Paul White continues his series on lock escalation by diving into the mechanics involving parallelism.

Paul White ◆ October 4, 2022

0

The Lock Escalation Threshold – Part 1

Paul White explains how and when lock escalation is triggered in SQL Server, clarifying misleading information you may have seen in official documentation and other sources.

Paul White ◆ September 6, 2022

1

Simple Parameterization and Trivial Plans — Part 6

Paul White concludes his series with trivial plans and when simple parameterization is considered safe or unsafe.

Paul White ◆ August 4, 2022

0

10 For 10 : My 10 Favorite SQLPerformance Posts Over 10 Years

On this site’s 10^th birthday, Aaron Bertrand looks back on his favorite posts – one from each year.

Aaron Bertrand ◆ July 24, 2022

0

Simple Parameterization and Trivial Plans — Part 5

Paul White continues his series on simple parameterization and trivial plans explaining how maximum plan reuse is achieved.

Paul White ◆ June 8, 2022

0

T-SQL Can Be Expressive Without Sacrificing Performance

There are often multiple ways to express a query and get the same results, often without any change in performance. Learn about one example.

Aaron Bertrand ◆ June 2, 2022

0

T-SQL Windowing Improvements in SQL Server 2022

Itzik Ben-Gan dives deep on two of the more interesting T-SQL enhancements in SQL Server 2022: the new WINDOW clause and the windowing NULL treatment clause.

Itzik Ben-Gan ◆ May 25, 2022

10

Simple Parameterization and Trivial Plans — Part 4

Paul White continues his series explaining how the parser affects simple parameterization and trivial plans. Learn more in part 4.

Paul White ◆ May 20, 2022

2

Simple Parameterization and Trivial Plans — Part 3

Paul White continues his series on simple parameterization and trivial plans with a look at the information available in execution plans.

Paul White ◆ April 18, 2022

2

Islands T-SQL Challenge

Itzik Ben-Gan introduces another T-SQL challenge; this time, it involves finding islands without explicit sort operators.