Archive for the 'T-SQL' Category

Goodbye IsNumeric hell

• Tuesday, July 26th, 2011

Posted in SQL Server, T-SQL | 8 Comments »


Converting OR to Union

• Tuesday, July 5th, 2011

Posted in Performance, SQL Server, Syndication, T-SQL | 7 Comments »


On Transactions, errors and rollbacks

• Tuesday, May 17th, 2011

Posted in SQL Server, Syndication, T-SQL | 10 Comments »


A Trio of Table Variables

• Tuesday, October 12th, 2010

Posted in SQL Server, Syndication, T-SQL | 27 Comments »


In, Exists and join – a roundup

• Tuesday, April 27th, 2010

Posted in SQL Server, Syndication, T-SQL | 5 Comments »


Left outer join vs NOT EXISTS

• Tuesday, March 23rd, 2010

Posted in SQL Server, Syndication, T-SQL | 8 Comments »


NOT EXISTS vs NOT IN

• Thursday, February 18th, 2010

Posted in SQL Server, Syndication, T-SQL | 15 Comments »


IN vs INNER JOIN

• Tuesday, January 12th, 2010

Posted in SQL Server, Syndication, T-SQL | 25 Comments »


EXISTS vs IN

• Monday, August 17th, 2009

Posted in SQL Server, Syndication, T-SQL | 8 Comments »


Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009

Posted in Performance, SQL Server, Syndication, T-SQL | 12 Comments »


« Previous Entries