What are the different sections in Page? | SQL Server Interview Questions

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 point to that data row.
General view of a Extent
                                                      General view of a Extent 

0 comments:

Post a Comment

Blogger news