Cari Blog Ini

24 Juli 2012

What is Pages in SQL Server ?

A page in Sql Server is the primary storage structure for all data
(data, indexes, BLOB/CLOB/LOB, row-overflow/SLOB, etc.).

Pages are 8k in size and store records in no particular order
(row offset is used to find each logical record on the page)
- a very basic structure is as follows:

Source:
http://www.mssqltips.com/sqlservertip/2261/sql-server-fragmentation-storage-basics-and-access-methods-part-1-of-9/