Posts

SQL Server 2008 MERGE statement

How to find a column reference in a given database schema

Break points in SQL Server

SQL OVER and PARTITION BY

Using SQL Profiler

Useful SQL shortcuts

Handy "SQL Queries"

Should I Use the sp_ Prefix for Procedure Names?

Difference between DateTime and SmallDateTime - SQL Dates and Times Series

SQL: COUNT Function:: What is the difference between count(1) and count(*) in a sql query