Transactions & Concurrency

  1. 🚧 Transactions & Savepoints β€” BEGIN/COMMIT/ROLLBACK, savepoints.
  2. 🚧 Isolation Levels β€” RC, RCSI, RR, SR, SI β€” phenomena and trade-offs.
  3. 🚧 Deadlock Basics β€” Reproducing and diagnosing deadlocks.
  4. 🚧 Locking Hints β€” WITH (NOLOCK) and other hints β€” risks and uses.