Archive for the 'T-SQL' Category

In, Exists and join – a roundup

• Tuesday, April 27th, 2010

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


Left outer join vs NOT EXISTS

• Tuesday, March 23rd, 2010

Posted in SQL Server, Syndication, T-SQL | 5 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 | 16 Comments »


EXISTS vs IN

• Monday, August 17th, 2009

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


Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009

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


On Counts

• Tuesday, April 14th, 2009

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


Dynamic SQL and SQL injection

• Friday, April 3rd, 2009

Posted in SQL Server, Syndication, T-SQL | 1 Comment »


Catch-all queries

• Thursday, March 19th, 2009

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


On the OUTPUT of a data modification

• Wednesday, December 31st, 2008

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


« Previous Entries