SQL Server Transactions are used to ensure that a series of statements written to modify data will pass the ACID test that enforces data integrity, accuracy, concurrency, and recoverability of the data in the database. The ACID properties of a transaction are…
- Atomicity – This ties several statements together to ensure that a series of statements in a transaction either succeed or fail together.
- Consistent – This is enforced by using transaction logs to ensure that only valid data that has been committed will be written to the database.
- Isolated – This is enforced by using locks to control concurrency. More specifically to make sure that a record being updated by one statement does not interfere with a separate statement trying to modify that same record or records.
- Durable – Once again transactions logs are used as a way of recovering data in case of a database failure. The recovery model of your database may also affect durability.
To learn more, check out this post on transactions and errors or this post on transaction isolation levels.
I was looking for the convincing details about the internal functioning of SQL server for a long time , suddenly while i was searching such contents on internet i got this web site which helped me a lot to clarify my doubts. The most effective part is anything which is explained is illustrated through image which is really quite convincing. My heartiest thanks to the team who took pain to make it available. God Bless you all.