T-SQL Queries Archives - SQLPerformance.com

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

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

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

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

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

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

14

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

Matching Supply With Demand — Solutions, Part 1

Itzik Ben-Gan presents initial solutions to his latest T-SQL challenge surrounding auctions (supply and demand).

Itzik Ben-Gan ◆ January 12, 2022

2

Matching Supply With Demand Challenge

Itzik Ben-Gan starts another T-SQL challenge series, this one about matching supply with demand (for example, an auction).

Itzik Ben-Gan ◆ December 8, 2021

33