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).
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Using the above is preferrable to using WITH (NOLOCK). See this blog entry and this one.