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

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize con...

Πλήρης περιγραφή

Λεπτομέρειες βιβλιογραφικής εγγραφής
Κύριος συγγραφέας: Korotkevitch, Dmitri (Συγγραφέας, http://id.loc.gov/vocabulary/relators/aut)
Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
Γλώσσα:English
Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2018.
Έκδοση:1st ed. 2018.
Θέματα:
Διαθέσιμο Online:Full Text via HEAL-Link
Πίνακας περιεχομένων:
  • 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.