Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

1. Data Storage and Access Methods.- 2. Transaction Management and Concurrency Models.- 3. Lock Types.- 4. Blocking in the System.- 5. Deadlocks.- 6. Optimistic Isolation Levels.- 7. Lock Escalation.- 8. Schema and Low-Priority Locks.- 9. Lock Partitioning.-10. Application Locks.- 11. Designing Transaction Strategies.- 12. Troubleshooting Concurrency Issues.- 13. In-Memory OLTP Concurrency Model.- 14. Locking in Columnstore Indexes.