Search

Lessons (3)

• Transactions, Indexes & Concurrency

  Interview answers for triggers, ACID, clustered indexes, deadlock/livelock and RAID. Covers PDF questions 8-11 and 18 …

• ACID, Transactions & Locks

  … This avoids a race without a distributed lock. Locks, deadlocks and good habits Locks protect conflicting work, but …

• Database Indexing & Transactions

  … are frequent Conflicts are rare Cost Waiting, possible deadlocks Retries on conflict Isolation levels Isolation controls what a …