Categories › T-SQL Queries
October 18, 2022 • by Itzik Ben-Gan

DATE_BUCKET and DATETRUNC Improve Optimization of Time-Based Grouping

no responses
July 13, 2022 • by Itzik Ben-Gan

Emulating the GROUPS Window Frame Option

7 responses
June 2, 2022 • by Aaron Bertrand

T-SQL Can Be Expressive Without Sacrificing Performance

no responses
May 25, 2022 • by Itzik Ben-Gan

T-SQL Windowing Improvements in SQL Server 2022

10 responses
May 11, 2022 • by Itzik Ben-Gan

Are You Sorted? Tips Concerning T-SQL Window Ordering

17 responses
April 13, 2022 • by Itzik Ben-Gan

Islands T-SQL Challenge

16 responses
March 9, 2022 • by Itzik Ben-Gan

Matching Supply With Demand — Solutions, Part 3

14 responses
February 17, 2022 • by Aaron Bertrand

String Aggregation Over the Years in SQL Server

3 responses
February 9, 2022 • by Itzik Ben-Gan

Matching Supply With Demand — Solutions, Part 2

4 responses
January 12, 2022 • by Itzik Ben-Gan

Matching Supply With Demand — Solutions, Part 1

2 responses
December 8, 2021 • by Itzik Ben-Gan

Matching Supply With Demand Challenge

33 responses
November 10, 2021 • by Itzik Ben-Gan

Fundamentals of Table Expressions, Part 13 – Inline Table-Valued Functions, Continued

2 responses
Load more from this category…
Design & content © 2012-2018 SQL Sentry, LLC.
All rights reserved.

User contributions are licensed under
cc-sa with attribution required.

Back to top