Don’t hog the db records

It has been a long time since I have put anything in here.  And, of course, my first entry in months is about… you guessed it… SQL.

This one is just a reminder to me to use the following code in queries to prevent the query from holding a lock on the table (I still don’t understand why a SELECT would hold a lock on a table – seems dumb to me).


Using the above is preferrable to using WITH (NOLOCK). See this blog entry and this one.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s