Browse by Tags

• Entering TRY blocks is not free, but still several times cheaper than catching exceptions.

  The 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 Read More... Posted Tuesday, July 26, 2011 11:15 AM by Alexander Kuznetsov | 9 Comments Filed under: Refactoring, T-SQL Performance, T-SQL Programming