SQL Server Architecture Question:
Download Questions PDF

Do you know what are pages and Extents?

Answer:

A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are: Date, text, index , page free space etc. The data rows are put on the page serially after the header.

Extents are units in which space is allocated to tables and indexes. An extent is 8 continuous pages. SQL Server has two types of extents: uniform and mixed extent. For efficient allocation, the SQL server does not allocate whole extents to tables with small amounts of data

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
What are logical database components?Please illustrate physical database architecture?