Avoid Locking Conflicts

By Bill Graziano on 18 September 2000 | 0 Comments | Tags: Locking


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.
Follow the link to Avoid Locking Conflicts...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 7,056 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email ThisSubscribe to this feedKick itSave to del.icio.usView blog reactions

Related Articles

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

Introduction to Locking in SQL Server (12 December 2007)

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK (11 October 2000)

Row Locking (13 August 2000)

Other Recent Forum Posts

Mirroring & Snapshots? (0 Replies)

sp_rename (2 Replies)

Data Transformation Services in SQL Server 2005 (0 Replies)

database is 350 gb?? (1 Reply)

Need a SQL Query (URGENT) (5 Replies)

ODBC conection problem (1 Reply)

History of Changing Attributes (14 Replies)

Specail characters in flat file (0 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

SQL Server Jobs