Blogs Louis Davidson in Blogs Trigger Validations and Isolation Levels Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is... 18 August 2020 9 min read
Blogs Louis Davidson in Blogs I Have an Exclusive Lock, My Row Is Safe, Right? Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was... 06 December 2018 7 min read
Kalen Delaney Row Versioning Concurrency in SQL Server The optimistic concurrency model assumes that several concurrent transactions can usually complete without interfering with each other, and therefore do... 05 June 2014 44 min read
Kalen Delaney SQL Server Concurrency: Locking, Blocking and Row Versioning Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data... 02 October 2012 2 min read
