T-SQL

What is Denormalization?

This is simply the process of combining smaller tables to make larger tables. This can be used to address problems with performance or scalability. This is usually caused by tables being stored in separate files on disks and when databases are being queried   there is a requirement for each several files to be accessed according… Continue reading What is Denormalization?

T-SQL

What is Normalization?

I would simply describe this as the process of making big tables into smaller tables. The proper definition is that database normalization is a method of reorganising data within tables to reduce the level of dependency. This helps to isolate data so that insertion, deletions and updates in a field can be made into a… Continue reading What is Normalization?

T-SQL

What is ACID ( Atomicity, Consistency, Isolation, Durability)?

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.… Continue reading What is ACID ( Atomicity, Consistency, Isolation, Durability)?