T-SQL correlated queries

The Performance of Window Aggregates Revisited with SQL Server 2019

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?

Fun addition

Short Variables

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

T-SQL Decommenter Part III

Detailed explanation of the recursive section of the T-SQL Decommenter.

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.