Books > Computing & IT > Computer software packages > Database software
|
Buy Now
Expert SQL Server Transactions and Locking - Concurrency Internals for SQL Server Practitioners (Paperback, 1st ed.)
Loot Price: R1,301
Discovery Miles 13 010
You Save: R369
(22%)
|
|
Expert SQL Server Transactions and Locking - Concurrency Internals for SQL Server Practitioners (Paperback, 1st ed.)
Expected to ship within 10 - 15 working days
|
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 concurrency issues in the
systems you develop. SQL Server's Concurrency Model is one of the
least understood parts of the SQL Server Database Engine. Almost
every SQL Server system experiences hard-to-explain concurrency and
blocking issues, and it can be extremely confusing to solve those
issues without a base of knowledge in the internals of the Engine.
While confusing from the outside, the SQL Server Concurrency Model
is based on several well-defined principles that are covered in
this book. Understanding the internals surrounding SQL Server's
Concurrency Model helps you build high-throughput systems in
multi-user environments. This book guides you through the
Concurrency Model and elaborates how SQL Server supports
transactional consistency in the databases. The book covers all
versions of SQL Server, including Microsoft Azure SQL Database, and
it includes coverage of new technologies such as In-Memory OLTP and
Columnstore Indexes. What You'll Learn Know how transaction
isolation levels affect locking behavior and concurrency
Troubleshoot and address blocking issues and deadlocks Provide
required data consistency while minimizing concurrency issues
Design efficient transaction strategies that lead to scalable code
Reduce concurrency problems through good schema design Understand
concurrency models for In-Memory OLTP and Columnstore Indexes
Reduce blocking during index maintenance, batch data load, and
similar tasks Who This Book Is For SQL Server developers, database
administrators, and application architects who are developing
highly-concurrent applications. The book is for anyone interested
in the technical aspects of creating and troubleshooting
high-throughput systems that respond swiftly to user requests.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.