Transactions and Exception Handling

Using T-SQL transactions to manage the behaviour of queries is always a balance between data integrity and client concurrency. In order to build high performance, well behaving data logic layers it is important that we understand this topic. In this session we will look at isolation levels (including the row versioning levels), locking and deadlocking. We’ll also look at the exception handling capabilities in 2005 and how they can be used to manage transactions in stored procedures.
Presented by Eric Allsop at SQLBits I
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 275 KB
    Samples available Sample Code 10 KB
  • SpeakerBIO
    Eric has been working with SQL Server since version 6.5. He is currently working for IMGroup the MS Worldwide BI Partner for the last 3 years. Prior to this he managed development effort for a number of dotcoms and another consultancy. Eric has presented multiple sessions for UK SQL Server User Group events and written for a number of magazines including Enterprise Server Magazine.
  • Video
    The video is not available to view online.