T-SQL

What is ACID ( Atomicity, Consistency, Isolation, Durability)?

Atomicity – this basically means the transaction works or doesn’t and is sometimes called the “all or nothing” rule. I always liken it to an Atomic bomb because they either work or fail. A failed transaction would then enter a state of rollback.

Consistency – this means only valid data is  written to the database. This means if the constraints, keys….. are violated the data would not be committed.

Isolation – this means that multiple transactions  should not impact other transactions which are occurring simultaneously.

Durability – this means when a transaction is successful all the pending changes are applied to the database.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.