How LAG compares to other techniques

LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques

To Inifinity and Beyond With 1=1

There is some code that might work, but could lead others astray in the future. Today Steve notes that we ought to write code that sets a good example, and a loop that potentially runs forever isn't that type of code.

STRING_SPLIT Separators

Getting the JSON Index

Default Time

Executing a TSQL batch multiple times using GO

Learn how to execute the same batch of SQL Server commands X number of times using the GO command.

A Lack of Error Handling

Not a lot of people use error handling in their T-SQL code.

Using Coalesce to Clean Up Reports

One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?

Zero or Hero?

Default OPENJSON