Buffer Management – Microsoft DB

SQL Architecture

November 11, 2023November 11, 2023adminLeave a Comment

SQL Server’s primary components are: • Relational Engine • Storage Engine • SQL OS Relational Engine: The Relational Engine, often known as the query processor, is a component of SQL Server that determines what your query needs to perform and how to execute it best. It oversees […]

SQL Server – ACID Properties

December 25, 2024December 25, 2024adminLeave a Comment

ACID Properties ACID (atomicity, consistency, isolation, durability) is a set of properties that guarantee that database transactions are processed reliably. Atomicity: Atomicity requires that each transaction is “all or nothing”: if one part of the transaction fails, the entire transaction fails, and the database state is left unchanged. Consistency: The consistency property ensures that any […]