O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Maintaining Data Consistency: Transactions and Locks

SQL Server 2000 is designed to serve multiuser environments. If multiple users try to access the same data, SQL Server must protect the data to avoid conflicting requests from different processes. SQL Server uses transactions and locks to prevent concurrency problems, such as avoiding simultaneous modifications to the same data from different users.

This chapter teaches you the following:

  • Basic concepts about transactions

  • How to use Transact-SQL statements to manage transactions

  • How to understand the common concurrency problems and avoid them when they arise

  • How to apply the right transaction isolation level

  • Lock types available in SQL Server

  • How to detect and avoid deadlocks

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required