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

submitted by ussherm(5285) 5 years, 6 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: 17

tags: NOLOCK StevenHarman locking SQL SQLServer another