David Tovee asked a great question in yesterday’s Mastering Query Tuning class. He asked his fellow students, “How many of you actually use TRY/CATCH?”
I turned it into a Twitter poll because I wanted to check a wider audience:
When the developers at my company write new queries, they use TRY/CATCH and exception handling:
— Brent Ozar (@BrentO) August 19, 2021
The poll results as of this writing mirrors the experience I see with clients: the vast majority of T-SQL code doesn’t have any error handling whatsoever.
When I do run across error handling in client queries,