1.

What Are Pages In Sql Server? How Many Types Of Pages Are There?

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.

A page in SQL Server is an 8 KB data storage area.
There are 8 types of pages:


Discussion

No Comment Found

Related InterviewSolutions