Microsoft SQL Server 2000 provides a method for obtaining meta data using information schema views. (more…)

Here’s a handy query for finding duplicates in a table. (more…)

I’m not always working with SQL Server, and sometimes keep forgetting which SQL join to use, this article keeps me refreshed and hopefully give you an overview of the three main join types: Inner, Left and Right.

(more…)