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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
