Return to Avoid Locking Conflicts
Avoid Locking Conflicts
Written by Bill Graziano on 18 September 2000
SQL Server uses locking to protect multiple transactions from trampling one another. This is a critical feature for any multiuser database system. It's also a necessary one if you want to provide concurrency between multiple transactions. High concurrency means many users can experience good response time with little conflict from other users.