SQL Server Page and Extents

Sql server Page is fundamental unit of data storage and allocated in data file. Data file is logically divided into pages starting from 0 to n, SQL Server reads and writes operations are performed at the page level. The collection of eight contiguous pages are known as extents i.e. 1 extent = 8 pages. All ...