Database – Page 3 – Parv The IT Geek

What is ACID ( Atomicity, Consistency, Isolation, Durability)? — Parv The IT Geek

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 theContinue reading “What is ACID ( Atomicity, Consistency, Isolation, Durability)? — Parv The IT Geek”

SELECT — Returning specific columns — Parv The IT Geek

There are many times where returning all the data held within all the columns in a table are unnecessary and inefficient. For example. SELECT * FROM HumanResources.Department If you expand out the HumanResources.Department then you will get a list of the columns as well as some information on the columns. To get only the DepartmentIDContinue reading “SELECT — Returning specific columns — Parv The IT Geek”