ACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&A

A transaction in SQL Server is a group of SQL statements that are treated as a single unit and they are executed by applying the principle “do everything or do nothing”

The acronym ACID was created by Andreas Reuter and Theo Harder in the year 1983, however, Jim Gray had already defined these properties in the late 1970’s.
Most of the popular databases such as SQL Server, Oracle, MySQL, Postgre SQL follows the ACID properties by default.

A - Atomicity
C - Consistency
I - Isolation
D - Durability

[rashmichinjoos]

Nice and simple explanation
Thank you😊

[chrisumali]

Thanks for the demo, and info. Have a great day

[rajendraprasad]

Explanation is good.. good concept.. easy understandable with examples..

[saisumanth]

I have right to learn = I must be your subscriber

[shivakotari]

The way of your explanation is easily reachable...phenomenal work broh but can you please share few videos on performance tuning

[bijianwu]

thanks for the clear and amazing content

[noobda.noobK]

Very informative, thanks for the detailed explanation.

[hasanmougharbel]

Hello man,
God bless your efforts.
I have a new question as a newbie.
How shall i use the server optimizer in sql managemnt studio, is there any inbuilt settings or parameters to optimize the server,
or is the server optimizer already configured to work optimally on my machine?
Thanks a lot.

[bhagyabiiliger]

Thanks for the information sir..
Please try to make an videos on SSIS...

[prudhvikumar]

Hi, Please make videos CPU, Memory, Missing indexes and Disk I/O issues how to do troubleshooting the issues.

[vijayanand-sdgo]

Hello Sir, its really great and I am fortunate to find something like this for a SQL DBA starter, please start a series on Performance Tuning with the below topics it will be very helpfull, Let me know if you have plans of starting any online paid course as well
1. Indexes and Index management
2. Compression level - rectifying improper compressions
3. Isolation levels
4. Partitions
5. Tuning Tools - Perfmon, Profiler and DTA
6. Updating Statistics
7. Extended Events
Thanks a lot for your help. Hoping for a reply!!!

[naveenkumar-nwne]

Thanks for the valuable video sir. Kindly upload the performance related videos in sql server