Linking to the Previous Row

One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.

Precedence

Arrays and Lists in SQL Server

Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.

Why Object Qualification is important.

You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.

Best Way to Calculate Age

Calendar Display with Language Specific Day/Month names

A stored procedure which takes a year and language as parameters and creates a calendar display for these parameters.

Distributed Transactions

Get a Return Every Time.

This article will show how you can produce a return regardless of variables passed and debugging tool for @SQL String.

TSQL Query

Writing Outer Joins in T-SQL

Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.