Archive for the 'T-SQL' Category

Goodbye IsNumeric hell

• Tuesday, July 26th, 2011

Converting OR to Union

• Tuesday, July 5th, 2011

On Transactions, errors and rollbacks

• Tuesday, May 17th, 2011

A Trio of Table Variables

• Tuesday, October 12th, 2010

In, Exists and join – a roundup

• Tuesday, April 27th, 2010

Left outer join vs NOT EXISTS

• Tuesday, March 23rd, 2010

NOT EXISTS vs NOT IN

• Thursday, February 18th, 2010

IN vs INNER JOIN

• Tuesday, January 12th, 2010

EXISTS vs IN

• Monday, August 17th, 2009

Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009