For reading dirty data you can set isolation levels at a Connection level using
Do any of these help with locking / blocking issues at a global level?
I added tags for transaction and isolation-level to your question. There are some good answers in some of the previous questions:
short answer: Yes, both help by reducing the need for locking but both also increase usage of tempdb.
answered Nov 18, 2009 at 02:39 PM