In what cases a developer should start considering setting the isolation level explicitly?

Under what conditions should a developer consider changing the default isol开发者_开发知识库ation level explicitly defined by the framework?

Thanks!

Almost never.

There are many clever RDBMS, .net, Jave etc engineers working for Microsoft, Oracle etc who know more than the average code monkey (me and you) about this kind of thing

Some SO questions about dirty reads:

• Default isolation level in Microsoft SQL Server 2005
• Using NOLOCK Hint in EF4?

And a recent blog article from SQL Server support team: "Inappropriate usage of high isolation level isn’t just about blocking when it comes to performance"