Archive for the 'T-SQL' Category

On Counts

• Tuesday, April 14th, 2009

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


Dynamic SQL and SQL injection

• Friday, April 3rd, 2009

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


Catch-all queries

• Thursday, March 19th, 2009

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


On the OUTPUT of a data modification

• Wednesday, December 31st, 2008

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


Common T-SQL mistakes

• Tuesday, May 20th, 2008

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


Comparisons with NULL

• Wednesday, January 16th, 2008

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


Temp tables and table variables

• Wednesday, December 19th, 2007

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


DateTime Manipulation

• Monday, November 5th, 2007

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


Data Conversion Woes, pt 2

• Thursday, July 12th, 2007

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


Data Conversion Woes

• Tuesday, July 10th, 2007

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


Next Entries »