Advanced Topics
From Accessing and Changing Relational Data
Accessing and Changing Relational Data
Advanced 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. Microsoft® SQL Server™ also supports nesting transactions, transaction savepoints, and bound transactions, which offer programmers additional options for writing efficient transactions.