Query Exercise Answer: Generating Big TempDB Spills

In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.

What is the PRODUCT

Putting the Player with the Number

5 Strategies to Refactor SQL Code

Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL.

T-SQL in SQL Server 2025: The UNISTR Function

I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]

Adding a Lot of Seconds

A New Operator

Which Object Definitions Are Available?

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:

T-SQL in SQL Server 2025: The PRODUCT Function

Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]