Chapter 32. Locking and Performance
IN THIS CHAPTER
This chapter examines locking and its impact on transactions and performance in SQL Server. It also reviews locking hints that you can specify in queries to override SQL Server’s default locking behavior.
What’s New in Locking and Performance
One of the key new features of SQL Server 2005 related to locking and performance is the new row version–based isolation levels, such as Read Committed Snapshot and Snapshot ...
Get Microsoft® SQL Server 2005 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
