SQLPerformance.com

Are You Sorted? Tips Concerning T-SQL Window Ordering

Queries with multiple ordering needs typically involve sorts in their plans. By following these tips, you can minimize the number of needed sorts. Learn more.

Itzik Ben-Gan ◆ May 11, 2022

17

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

16

The SQL Server Transaction Log, Part 3: The Circular Nature of the Log

Paul Randal continues his series on the SQL Server transaction log, discussing its circular nature and the challenges involved. Learn more.

Paul Randal ◆ April 5, 2022

3

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

4

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

15

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.

Aaron Bertrand ◆ February 17, 2022

3

Matching Supply With Demand — Solutions, Part 2

Itzik Ben-Gan continues exploring solutions to a T-SQL challenge involving matching supply with demand.

Itzik Ben-Gan ◆ February 9, 2022

4

The SQL Server Transaction Log, Part 2: Log Architecture

Paul Randal lays some groundwork around the architecture of the SQL Server transaction log.

Paul Randal ◆ February 1, 2022

2

The SQL Server Transaction Log, Part 1: Logging Basics

Paul Randal starts a new blog series to dive deep into every aspect of the SQL Server transaction log.

Paul Randal ◆ January 20, 2022

5