“I've received a lot of support from fellow pessimists. I've considered starting a support group, but nobody thinks it will help.” -- https://twitter.com/raganwald/
The following caught my attention on SQL Server 2014 announcement:
“Taking the Optimistic Approach
The Hekaton team also found that multi-version concurrency control (MVCC) proved robust in scenarios with higher workloads and higher contention”
MVCC greatly reduces deadlocks. Let’s hope SQL Server team make MVCC turned on by default on SQL Server 2014 like what Entity Framework team did on its EF6’s code first’s database creation:
Default transaction isolation level is changed to READ_COMMITTED_SNAPSHOT for databases created using Code First, potentially allowing for more scalability and fewer deadlocks. -- http://entityframework.
Happy Computing! ツ