Transactions & Concurrency
- π§ Transactions & Savepoints β BEGIN/COMMIT/ROLLBACK, savepoints.
- π§ Isolation Levels β RC, RCSI, RR, SR, SI β phenomena and trade-offs.
- π§ Deadlock Basics β Reproducing and diagnosing deadlocks.
- π§ Locking Hints β WITH (NOLOCK) and other hints β risks and uses.