Transactions 1

Investigating Transactions Using Dynamic Management Objects

There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?

Triggers and Transactions

Fun with Transactions - Part IV

Fun with Transactions - Part III

Fun with Transactions - Part II

Fun with Transactions - Part I

Transaction rowcount

The power of batching Transactions

This article analyzes the performance gains of batching multiple DML statements into a single transaction. New author Manor Lev-Tov examines the effect of grouping statements together instead of running them all as separate transactions.

Transactions