Advanced Transactions Topics
Mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users in a system increases, it becomes important to have applications that use transactions efficiently. The SQL Server Database Engine also supports nesting transactions, transaction savepoints, and bound transactions, which offer programmers additional options for writing efficient transactions.
Explains how to nest transactions in stored procedures that can be called from sessions that may or may not have an active transaction.
Savepoints offer a mechanism to roll back portions of a transaction.
Two sessions can be bound, in which case they share a common transaction and set of locks.
Choosing an isolation level defines how the current session is isolated from updates performed by other sessions.
Discusses the behaviors associated with rolling back a transaction from a stored procedure or trigger.
Certain statements cannot be run from an active transaction.
Discusses recommendation for coding transactions that perform and scale well.