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

[@chrisumali9841]

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

[@noobda.noob2K24]

Very informative, thanks for the detailed explanation.

[@bijianwu5124]

thanks for the clear and amazing content

[@rajendraprasad9040]

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

[@rashmichinjoos9394]

Nice and simple explanation
Thank you😊

[@hemalwatts9627]

Great explanation. Thank you!!

[@hasanmougharbel8030]

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.

[@shakedm7256]

Thank you for this!

[@bhagyabiiliger7161]

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

[@naveenkumar-nw7ne]

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

[@ajitpradhan-tw4uq]

its really nice sir

[@shivakotari2181]

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

[@righttolearnbk]

Thank you and sure I will do in coming days

[@Boss-vt5fv]

Thanks a lot 👍

[@tanshitalks]

Tq bro, good explanation

[@vijayvlog5039]

Thanks

[@RishiRap]

Nice!

[@vijayanand-sd4go]

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!!!

[@righttolearnbk]

Thanks for your suggestion and I will start in coming days.

[@prudhvikumar6785]

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

[@righttolearnbk]

👍

[@vinoddevops3000]

cleared lot of doubts.