Archive for the 'T-SQL' Category

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

On Counts

• Tuesday, April 14th, 2009

Dynamic SQL and SQL injection

• Friday, April 3rd, 2009

Catch-all queries

• Thursday, March 19th, 2009

On the OUTPUT of a data modification

• Wednesday, December 31st, 2008

Common T-SQL mistakes

• Tuesday, May 20th, 2008

Comparisons with NULL

• Wednesday, January 16th, 2008