Issues with IsDate()

IsDate function returns 1 for a numeric value

Contiguous Time Periods

It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were difficult to solve with constraints. Joe Celko explains.

Before Insert or Update Trigger

RANK() returns consecutive integers

TRUNCATE in TRANSACTION

Identity Property Range Checking in SQL Server

This article examines practical methods of managing and monitoring large tables which make use of the IDENTITY property.

T-SQL

Swap columns

Understanding T-SQL Expression Short-Circuiting

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.

Improving 2D Range Query Performance in SQL Server

When using the BETWEEN operator on multiple columns, you are likely using a 2D range query. Such queries perform very poorly in SQL Server. This article examines rewriting these queries for improved performance.