36 Chambers – The Legendary Journeys: Execution to the max!

Video: Tuning Window Functions in SQL Server

Kevin Feasel — Tue, 14 Oct 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I show you various techniques you can use to make window functions faster, including proper indexing and usage of batch mode. I also demonstrate the performance difference between RANGE and ROWS.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Limitations of Window Functions in SQL Server

Kevin Feasel — Tue, 07 Oct 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I take you through some of the limitations of window functions in SQL Server, including the lack of intervals and oddities around the APPLY operator.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Use Cases for Window Functions

Kevin Feasel — Tue, 30 Sep 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I take you through a variety of use cases for window functions, showing how you can solve common (and sometimes uncommon) business problems efficiently and effectively.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Types of Window Functions in SQL Server (Part 2)

Kevin Feasel — Tue, 23 Sep 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I continue a dive into each category of window function, quickly reviewing the four categories of window function (plus ordered set functions). Then, I cover offset window functions, statistical window functions, and ordered set functions.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Types of Window Functions in SQL Server (Part 1)

Kevin Feasel — Tue, 16 Sep 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I walk through four categories of window function, plus a somewhat-related type of function in SQL Server. From there, I demonstrate how aggregate window functions and ranking window functions work.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Window Functions in SQL Server

Kevin Feasel — Tue, 09 Sep 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video (part 1 of a new series), I explain what a window function is, as well as the components of window functions.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Reshaping Data with APPLY

Kevin Feasel — Tue, 10 Jun 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I show how we can use the APPLY operator to reshape datasets, allowing us to unpivot tables and also calculate the greatest and least values for a row.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Simplifying Calculations with APPLY

Kevin Feasel — Tue, 03 Jun 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I show how we can use the APPLY operator to remove redundancy in the SELECT clause and simplify complex calculations, all with zero performance impact.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Retrieving Child Records with APPLY

Kevin Feasel — Tue, 27 May 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the latest record, as well as any arbitrary number of records. We also spend time digging into under what circumstances the APPLY operator out-performs other common options.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Video: Pre-Aggregating Data with APPLY

Kevin Feasel — Tue, 13 May 2025 13:45:00 +0000

THE VIDEO

THE SYNOPSIS

In this video, I show how we can use the APPLY operator to operate on ad hoc functions. That leads to a powerful use case: pre-aggregating data.

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.