1.

Explain page, A fundamental unit of storage in SQL Server and different types of pages.

Answer»

A page is a fundamental UNIT of storage that stores data. The page is the size of 8KB and we have 8 types of pages in SQL Server.

  • Data
  • Index
  • Text/Image (LOB, ROW_OVERFLOW, XML)
  • GAM (Global ALLOCATION Map)
  • SGAM (Shared Global Allocation Map)
  • PFS (Page Free Space)
  • IAM (Index Allocation Map)
  • BCM (Bulk CHANGE Map)
  • DCM (Differential Change Map)


Discussion

No Comment Found