Korotkevitch, Dmitri
Expert SQL Server Transactions and Locking
- ISBN 13:
- 9781484239568
- author:
- Korotkevitch, Dmitri
- format:
- Paperback
- publisher:
- Apress
- language:
- English
- Publication Year:
- 2018
- Pages:
- 357
- Dimensions:
- 25.4 x 17.8 centimetres
- Genre:
- Computers, Server & Database, General Database,
- Condition:
- New
- Availability:
- Item usually sent within 20 working days
Description
Mastering SQL Server's Concurrency Model is crucial for building high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address common concurrency issues, such as blocking problems and deadlocks, and provides guidance on writing code and designing database schemas to minimize these issues. By understanding the internals of SQL Server's Concurrency Model, you can build reliable systems in multi-user environments. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and explores new technologies like In-Memory OLTP and Columnstore Indexes. With this knowledge, you'll be able to address concurrency issues and create high-performance databases. This comprehensive guide is ideal for developers and database administrators who want to improve their skills in handling concurrency and locking in SQL Server.