Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Month: October 2011

  • SQL Server: When to Use the TSQL WITH NOLOCK Hint

    MS SQL Server allows using the TSQL hint ‘WITH (NOLOCK)’ to the joins of SELECT statements. At times the WITH (NOLOCK) hint can be justified and useful, but it comes with inherent dangers that are often ignored or not understood. The WITH (NOLOCK) hint is often overused or is used when it should not be.…

  • MS SQL Server: Temporary Table and Table Variable Performance

    Temporary tables and table variables in SQL Server actually perform quite differently under different circumstances. Temporary tables are decelared as: CREATE Table #TableName ( id INT ) Table variables are declared as: DECLARE @TableName TABLE ( id INT ) Temporary tables are transaction bound whereas table variables are not. This means that if a transaction in…

  • SQL Server 2008 – Using TRY – CATCH Blocks

    With SQL Server 2008 Microsoft has added .NET like error handling to SQL Server by adding support for TRY – CATCH blocks. I like this new feature since the old @@ERROR syntax was quite unwieldy and the TRY – CATCH just seems more intuitive to use. Here are some of the features of the new TRY –…