6.4. Manage Special Transaction Situations
There are a number of special situations that you will run into when working with transactions in SQL Server as well as important information that you will have to know. In this section, we will address those remaining issues, including performance and concurrency factors, controlling time-outs, and handling deadlocks.
6.4.1. Concurrency and Performance
For all the problems that transactions can solve with regard to data integrity, they can create just as many problems relating to concurrency and performance. It is critical that you consider these issues when planning your transactional strategies as well as your lock isolation and hinting structure. Being aware of the problems is half the battle, ...