Alexander Kuznetsov : Refactoring, T-SQL Performancehttp://sqlblog.com/blogs/alexander_kuznetsov/archive/tags/Refactoring/T-SQL+Performance/default.aspxTags: Refactoring, T-SQL PerformanceenCommunityServer 2.1 SP2 (Build: 61129.1)Entering TRY blocks is not free, but still several times cheaper than catching exceptions.http://sqlblog.com/blogs/alexander_kuznetsov/archive/2011/07/26/entering-try-blocks-is-not-free-but-still-eight-times-cheaper-than-catching-exceptions.aspxTue, 26 Jul 2011 15:15:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37264Alexander Kuznetsov9http://sqlblog.com/blogs/alexander_kuznetsov/comments/37264.aspxhttp://sqlblog.com/blogs/alexander_kuznetsov/commentrss.aspx?PostID=37264The overhead of entering a TRY block is relatively small, but the overhead of catching an exception is more substantial. If we manage to use CASE or IF to prevent an exception, we can noticeably improve performance. We shall run benchmarks and see for...(<a href="http://sqlblog.com/blogs/alexander_kuznetsov/archive/2011/07/26/entering-try-blocks-is-not-free-but-still-eight-times-cheaper-than-catching-exceptions.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=37264" width="1" height="1">RefactoringT-SQL PerformanceT-SQL Programming