Why isn't Snapshot isolation supported with Di

2019-08-01 07:40发布

Question is in the title. I'd just love to understand why this isn't supported?

Just to clarify this is MS Sql Server 2005 / 2008.

1条回答
Emotional °昔
2楼-- · 2019-08-01 08:21

Because it's potentially inconsistent and it's weaker out of the box than lock-based isolation (ANSI SQL).

Or, the downsides (such as this banking example) require more work and thinking to keep things correct so it's simply safer not to support it.

Finally (I've not checked), is it in the ANSI standard? It could be a very bespoke solution and you'd be unable to use distributed transactions against other platforms

Link 1

查看更多
登录 后发表回答