Microsoft® SQL Server® 2008 T-SQL Fundamentals

Chapter 9. Transactions and Concurrency

In this chapter:

Transactions

Locks and Blocking

Isolation Levels

Deadlocks

Conclusion

Exercises

This chapter covers transactions and their properties, and describes how Microsoft SQL Server handles concurrent users trying to access the same data. The chapter explains how SQL Server uses locks to isolate inconsistent data, how to troubleshoot blocking situations, and how to control the level of consistency you get when querying data with isolation levels. The chapter also covers deadlocks and ways to mitigate their occurrence.

Note that this chapter is just an introduction to these topics, many of which can become quite complex. You can find more information on these topics in SQL Server Books ...