GSquared (11/7/2012)
Standard, normal, boring Read Committed usually works just fine for that kind of situation.If you find that the few in-day updates are causing more blocks than you like, switch to RCSI. Not to Read Uncommitted.
The locks are heldup for longer durations, how do i handle that?