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, ...

Get SQL Server® 2008 Administration: Instant Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.