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.
Article: Avoid Locking Conflicts
Posted - 09/18/2000 : 11:16:56
