Day: September 29, 2015

Optimistic Concurrency in SQL Server

09/29/2015 09/29/2015 / By Klaus Aschenbrenner / SQLServer / Leave a Comment

Today I want to talk about Optimistic Concurrency in SQL Server. A few weeks ago I have already blogged about Pessimistic Concurrency that is the default concurrency model that SQL Server uses out of the box. Row Versioning Optimistic concurrency was introduced back with SQL Server 2005 and is based on the principles of Row …

Optimistic Concurrency in SQL Server + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.