Korotkevitch, Dmitri

Expert SQL Server Transactions and Locking

(No reviews yet) Write a Review
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
£43.46

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.

View AllClose