The Large Encoded Value

Controlling SQL Window Functions with Framing

I’ve used SQL window functions for years, but I’ve never fully understood framing. To truly master window functions, you need at least a basic grasp of framing and how to apply it to your queries. Framing is especially helpful when working with aggregate functions. How can you overcome this hesitation to try framing?

T-SQL in SQL Server 2025: The || Operator

I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]

SQL Server 2025 Product() Function Examples

SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.

UNISTR Basics

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 […]