Storage is a core component of any RDBMS system. In SQL Server, the smallest unit of storage is page. Every page is about eight KB in size and has three main sections; page header, page record and row offset array. Depending upon the contents of the records we can have different types of pages. Extent is a collection of eight continuous pages. In the first exercise of this lab we will explore database pages and their types. In the second exercise we will look at different types of records. And in the third exercise we will look at extents and their types.

Subscribe to Download

File Size876.42 KB
Create DateSeptember 7, 2016
Last UpdatedSeptember 12, 2016