« Why Lock(typeof(ClassName)) or SyncLock GetType(ClassName) Is Bad | Main | Building a Challenge/Response Spam Blocking System »
January 06, 2004
SQL Server Locks - NOLOCK and ROWLOCK
I found a decent article that seems to explain proper use of NOLOCK and ROWLOCK. When working with large amounts of data, not using ROWLOCK can cause serious performance problems, for example incoming queries can basically be blocked by a SELECT statement to that table or even a JOIN on that same table. Note that SQL Server Optimizer hint NOLOCK is indentical to setting the transaction isolation level to READ UNCOMMITTED.
Posted by 0xFF3300 at January 6, 2004 06:20 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)