Learning the SQL GROUP BY Clause

Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.

The Record That Never Existed (as a committed row)

Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]

Implicit conversion from datetime to datetime2

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.