How should Transactions be used in production for SQL Server?

Keep transactions short, choose isolation levels deliberately, handle retries for transient failures, and avoid unnecessary work inside the transaction boundary.