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: 1444 | Points: 40
Answer:

A Page in Sql Server is an 8 KB data storage area .
There are 8 types of pages:
1. Data
2. Index
3.Text/Image
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