Expert SQL server transactions and locking : concurrency internals for SQL server practitioners /: concurrency internals for SQL server practitioners. (2018)

• Record Type: Book
• Further Information: Note: Dmitri Korotkevitch.
• Authors: Korotkevitch, Dmitri
• Contents: 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.
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2018
• Extent: 1 online resource (xix, 320 pages), illustrations
• Subjects: 005.74; Database management; Database Management; COMPUTERS / Databases / Servers; Computer multitasking; Electronic books
• Languages: English
• ISBNs: 9781484239575; 1484239571
• Related ISBNs: 9781484239568; 1484239563; 9781484239582; 148423958X
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.