Masterclass: A Day in the Life of a Database Transaction
Every data modification that you ever do in your database is a transaction. Do you know how this affects your performance? Do you know what is the best way to code your transactions to achieve maximum performance without compromising transactional consistency? Do you know how to use different transaction isolation levels and locking hints? Do you properly handle errors, especially deadlocks, within your transactions? Come to this session to learn everything about transactions--logging, recovery, performance, isolation levels, and handling nested and distributed transactions.