f0ddf54b_ction_and_Locks_in_MS_SQL_2008__READ_COMMITTED
[Lock TYPE] Consistency ISSUE within current TRANS [READ UNCOMMITTED] Yes [REPEATABLE READ] No [SERIALIZABLE] No [READ COMMITTED SNAPSHOT] Yes [SNAPSHOT] No [READ COMMITTED] 
Yes
N o
Y e s
N O
NotNullOrEmpty: Transaction and Locks in MS SQL 2008
READ COMMITTED