SQL Server Internals: Storage Engine and Data Consistency
1. Physical Storage Architecture
To the Operating System, SQL Server is simply reading and writing files. Internally, however, it manages a strict hierarchy of logical units.
1.1 File Structure
Every database consists of two primary physical files lo...
sqlinsights.hashnode.dev4 min read