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 there a row in inserted/deleted... 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 less wordy in my 30s... 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 not require draconian locking on... 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 because another application has it... 02 October 2012 2 min read
