ACID Properties of SQL Server

Many a times, in an interview, one common question is asked i.e. "What are the ACID properties of the SQL server?", so let us see, as per an interview perspective, what they are:
A - Stand for Atomicity
C - Stands for Consistency 
I - stands for Isolation
D - Stands for Durability
Atomicity
All the operations in the transaction must be complete, successfully and be committed; if any one of the operations fails then all the transactions must be rolled back in their previous state.
 Consistency
The transaction must be consistent in a state; this means that the transaction must correctly change the state of the system for a particular operation.
 Isolation
It means that one operation within the transaction cannot see the result of another operation within the transaction.
 Durability
It means that anything committed to the managed resources must survive or failure and it cannot be done the damages to the resources in case of operation fails.
 Summary
I hope this small blog is useful for the interview perspective and for more details please refer to MSDN. If you have any suggestion regarding this blog then please contact me.

Post a Comment

www.CodeNirvana.in

Protected by Copyscape
Copyright © Compilemode