SQLPerformance.com

SQLPerformance 2.0: The Next Chapter

SQLPerformance is back. For years, it’s been a trusted home for deeply technical, real-world guidance for SQL Server professionals, and that mission matters more than ever in today’s more complex, fast-moving database environments. If you’ve spent any time tuning SQL Server and Azure SQL, there’s a good chance SQLPerformance has crossed your path. For years, […]

Kevin Kline ◆ May 28, 2026

2

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

DATE_BUCKET and DATETRUNC Improve Optimization of Time-Based Grouping

Following the release of SQL Server 2022 RC1, Itzik Ben-Gan explores the new DATE_BUCKET and DATETRUNC functions for time-based grouping.

Itzik Ben-Gan ◆ October 18, 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

New Bit Manipulation Functions in SQL Server 2022

Itzik Ben-Gan takes an interesting look at new bit manipulation functionality in SQL Server 2022, including GET_BIT, SET_BIT, RIGHT_SHIFT, and LEFT_SHIFT.

Itzik Ben-Gan ◆ September 21, 2022

6

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

Additional T-SQL Improvements in SQL Server 2022

Itzik Ben-Gan takes a look at T-SQL improvements in SQL Server 2022 CTP 2.1 : The DISTINCT FROM predicate and new approximate percentile functions.

Itzik Ben-Gan ◆ August 1, 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

The SQL Server Transaction Log, Part 4: Log Records

Paul Randal continues his series on the SQL Server transaction log, this time describing the internals of log records.

Paul Randal ◆ July 19, 2022

6

Emulating the GROUPS Window Frame Option

Itzik Ben-Gan shows two supported approaches to mimic the GROUPS window frame option, which is part of the SQL standard but currently unsupported in SQL Server.

Itzik Ben-Gan ◆ July 13, 2022

7