The fundamentals of transactions

A transaction is a logical unit of work made up of one or more tasks. In general, a transaction is considered to have four primary characteristics: atomicity, consistency, isolation, and durability (ACID). The following is a brief explanation of these characteristics:

  • Atomicity: The transaction is an atomic unit of work in which every task within that transaction must be completed
  • Consistency: The transaction must leave all of the data in a consistent state
  • Isolation: The changes made by concurrent transactions must be isolated from each other, which means that no transaction should find data in an indeterminate state (in the process of change)
  • Durability: The changes made by the transaction are persisted

In SQL Server, ...

Get SQL Server 2014 Development Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.