Pages and Extents

Pages and Extents are core concept of data storage in SQL Server. A Page is a 8Kb space allocated in physical drive to be used by SQL Server. Managing these 8Kb Pages would have been difficult and so to help in it we have Extent which is a collection 8 Pages. As stated before a […]