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[....]

Read More