Application Locks (or Mutexes) in SQL Server 2005(sqlteam.com)

submitted by spirit1(3160) 4 years, 1 month ago

Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in a analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server. read more...

add a comment |category: Database |Views: 6

tags: locking Database another

Introduction to Locking in SQL Server(sqlteam.com)

submitted by spirit1(3160) 4 years, 1 month ago

Locking is a major part of every RDBMS and is important to know about. It is a database functionality which without a multi-user environment could not work. read more...

add a comment |category: Database |Views: 5

tags: SQLServer locking Database 2005 another

Get Around Database Locks with the NOLOCK Keyword(stevenharman.net)

submitted by ussherm(5285) 5 years, 3 months ago

Using MBUnit's awesome Rollback attribute for unit tests cause the test to be wrapped in a transaction - which is well and good as that allows any changes made by the test to be undone. However, it also causes a database lock contention when you try to read from a locked row/table while debugging your unit test. Read on for a quick tip to get around this issue. read more...

add a comment |category: Tips & Tricks |Views: 16

tags: NOLOCK StevenHarman locking SQL SQLServer another

Threading - Never Lock This Redux(haacked.com)

submitted by jimholmes(215) 5 years, 6 months ago

Why locking on "this" can be a bad idea -- and how to lock in a safer manner. read more...

add a comment |category: Tips & Tricks |Views: 4

tags: Haacked locking lock threading another