Nice easy question.
Koen Verbeeck (4/19/2012)
SQLRNNR (4/19/2012)
There needs to be more questions on isolation levels.Looking at the current score, certainly. 32% for Read Committed.
If Snapshot Isolation was one of the answers, I would understand a lot of people getting it wrong, but this isn't the case.
Yes, some education is needed in this area. The results aren't quite as bad now as when Koen saw them, but currently 27% opted for for READ COMMITTED (the second lowest isoaltion level) which is certainly not good. And the thing that really gets me is 2% saying Read Uncommitted!
Tom