SQL Server: The Internal Structure of the Data Page

The Page in a SQL Server is a small storage unit of data and it resides in a Data File. When we write the first row in a table, it creates an 8KB page to store the data, and it assigns 0 as a starting number and sequentially increase in a data file. Each data … Continue reading SQL Server: The Internal Structure of the Data Page