What are the Different Sections in Page?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 5700

Page has three important sections:

  • Page header

  • Actual data i.e. Data row

  • Row pointers or Row offset

Page header has information like timestamp, next page number, previous page number etc.

Data rows are where your actual row data is stored. For every data row, there is a row offset which points to that data row.

General view of a Extent

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response