SQLTeam.com Logo

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.