What do you think?
Rate this book
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
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
342 pages, Paperback
Published October 11, 2018
9 people are currently reading
15 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
February 1, 2024
It is an amazing book written with clarity. The book will help you understand, develop a strong mental model for transactions in SQL Server and provides practical troubleshooting techniques to fix performance issues. It’s must read if you would like to get ahead and scale systems under load.
Displaying 1 of 1 review