dbcc useroptions gives me what isolation level is set on the system. How do i find if it is pessimistic or optimistic?
In which situations do we change the server wide isolation levels? eg in OLTP vs Reporting vs DSS
What have you observed in your environments?
View Complete Post