Transactions

This article will compare the SQL Server XACT_STATE and @@TRANCOUNT functions and illustrate the differences with examples.

This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.

Learn what can and cannot be done for SQL Server DDL statement behavior inside a transaction when using the snapshot isolation level.

In this article we discuss the READ_COMMITTED_SNAPSHOT database option and how it can change the behavior of transactions running under the READ COMMITTED transaction isolation level.

In this tip, we are going to use savepoints to provide a third solution to the problem of mismatching the number of Transaction Control Language (TCL) commands in nested SQL Server stored procedures.

In this tip we cover how to use SQL Server transaction savepoints and how the impact transactions.

Learn how to solve SQL Server Deadlocks with multiple foreign keys columns when a table scan is occurring.

In this tip we look at how SQL Server deadlocks occurred for a database with a small set of data.

I noticed that when some queries run a lot of transaction log space is utilized. Can you explain how the transaction log gets used and why it doesn't always free up space after issuing transaction log backups.

Can DDL commands be used in transactions in SQL Server and Oracle? Read this tip to learn the differences between SQL Server and Oracle.