I mentioned SQL Server locking a few months ago, but it is important enough of a topic that I'm going to drop a quick blog post about it again. Actually, I'll just reference another blog posting from our friends at Neudesic that talks about one of my favorite SQL hints - "WITH (NOLOCK)"

http://blogs.neudesic.com/blogs/phil_scott/archive/2005/12/05/11.aspx

~Brad