SQL in the Wild » T-SQL

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 | 5 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 | 14 Comments »

IN vs INNER JOIN

• Tuesday, January 12th, 2010

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

EXISTS vs IN

• Monday, August 17th, 2009

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

Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009

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