What do we mean by Pages in Sql Server and How many types of pages are there?

 Posted by vishalneeraj-24503 on 2/2/2015 | Category: Sql Server Interview questions | Views: 478 | Points: 40

A Page in Sql Server is an 8 KB data storage area .
There are 8 types of pages:
1. Data
2. Index
4. Global Allocation Map, Shared Global Allocation Map
5.Page Free Space
6. Index Allocation Map
7. Bulk Changed Map
8. Differential Changed Map

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response