Using Outer Joins

Optimize SQL LIKE Wildcard Searches

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

The LAGging NULL

No Renames

The LAGing data

Troubleshoot Chained SQL Server CTE

This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.

Code Blocks

Crazy Code I

STRING_AGG's behavior

Converting Old Running Total Code to Window Functions

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.