SET XACT_ABORT is one of the hidden gem we can say. It is helpful in many ways.Let me explain by an example suppose you are working on a stored procedure which is doing a complex data manipulation. You though this query will run with in 1 minute when you run it from .NET or other …