SQL Server Isolation Levels
SQL Server Isolation Levels Notes (PASS 2013) Atomicity - Everything succeeds or nothing succeeds. This is the idea with transactions. Consitency - Data cannot be left in an inconsistent state. Isolation - No transaction can interfere with any other transactions. Locking - Pessimistic Versioning[....]