SQL Performance Archives - SQLPerformance.com

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

8

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.

Itzik Ben-Gan ◆ April 13, 2022

14

Simple Parameterization and Trivial Plans — Part 2

Paul White continues his series on simple parameterization and trivial plans with a look at the data types assigned to parameters. Learn more in part 2.

Paul White ◆ March 29, 2022

0

Simple Parameterization and Trivial Plans — Part 1

Paul White embarks on a new series covering less well-known details about simple parameterization and trivial plans. Learn more in part 1.

Paul White ◆ March 22, 2022

1

Matching Supply With Demand — Solutions, Part 3

Itzik Ben-Gan looks at additional interesting solutions to his supply and demand T-SQL challenge.

Itzik Ben-Gan ◆ March 9, 2022

12

String Aggregation Over the Years in SQL Server

Aaron Bertrand talks about progress in string aggregation—both in the functionality offered by SQL Server and the quality of his own code samples.