ANSI NULLS

Working with the INSERT statement in SQL Server

The INSERT statement in SQL Server is versatile. It now allows the insertion of multiple rows of literal values. It also provides the output clause that solves a number of common problems such as ascertaining the value of identity fields, and other calculated fields in tables, or for auditing the rows that are added to tables. Robert, once again, gives a clear introduction.

Persisted vs Non-persisted Computed columns

DATALENGTH

Index on computed columns

ISNUMERIC

Eliminating Duplicate Rows using The PARTITION BY clause

The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.

Round

Minesweeper in T-SQL

Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pummelling recalcitrant correlated subqueries.

Identifying and Eliminating the Dreaded Cartesian Product

Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.