Murach's SQL Server 2008 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 504
How transactions maintain data integrity 504
SQL statements for handling transactions 506
How to work with nested transactions 508
How to work with save points 510
An introduction to concurrency and locking 512
How concurrency and locking are related 512
The four concurrency problems that locks can prevent 514
How to set the transaction isolation level 516
How SQL Server manages locking 518
Lockable resources and lock escalation 518
Lock modes and lock promotion 520
Lock mode compatibility 522
How to prevent deadlocks 524
Two transactions that deadlock 524
Coding techniques that prevent deadlocks 526
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.