October 2021


October 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
  • Optimistic Locking Using a Version Column – Locking and Latching

    This is a simple implementation that involves adding a single column to each database table you wish to protect from lost updates. This column is…

    READ POST ➔

  • What Are Locks?- Locking and Latching-2

    Exactly the same issue affected concurrent updates (since an UPDATE was really a DELETE followed by an INSERT in SQL Server). Perhaps this is why…

    READ POST ➔