Murach's SQL Server 2005 for Developers
How to manage transactions and locking

This chapter explains how SQL Server manages concurrent changes to database data in a multi-user environment and shows how you, as a developer, can use transactions and locking to prevent data errors.
Chapter 16 How to manage transactions and locking
How to work with transactions 472
How transactions maintain data integrity 472
SQL statements for handling transactions 474
How to work with nested transactions 476
How to work with save points 478
An introduction to concurrency and locking 480
How concurrency and locking are related 480
The four concurrency problems that locks can prevent 482
How to set the transaction isolation level 484
How SQL Server manages locking 486
Lockable resources and lock escalation 486
Lock modes and lock promotion 488
Lock mode compatibility 490
How to prevent deadlocks 492
Two transactions that deadlock 492
Coding techniques that prevent deadlocks 494
Perspective 496
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.