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.

Topic

Description

Nesting Transactions

Explains how to nest transactions in stored procedures that can be called from sessions that may or may not have an active transaction.

Transaction Savepoints

Savepoints offer a mechanism to roll back portions of a transaction.

Using Bound Sessions

Two sessions can be bound, in which case they share a common transaction and set of locks.

Adjusting Transaction Isolation Levels

Choosing an isolation level defines how the current session is isolated from updates performed by other sessions.

Rollbacks and Commits in Stored Procedures and Triggers

Discusses the behaviors associated with rolling back a transaction from a stored procedure or trigger.

Transact-SQL Statements Allowed in Transactions

Certain statements cannot be run from an active transaction.

Coding Efficient Transactions

Discusses recommendation for coding transactions that perform and scale well.