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.