24 Hours of PASS: Summit 2017 Preview

On Transactions and Atomic Operations

Speaker: Gail Shaw

Duration: 60 minutes

Track: Build

"If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

1) Understand what transactions are and what they do.

2) Learn how to use transactions in combination with error handling to roll back changes on errors

3) Learn how transactions affect logging and locking.

"

Accompanying Material

No material found.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

Gail Shaw
Technical Lead, Entelect

Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL... View More

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids