top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is extent in SQL Server?

+2 votes
461 views
What is extent in SQL Server?
posted Dec 28, 2013 by Atul Mishra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Extent is a basic unit of storage to provide space for tables. Every extent has a number of data pages. As new records are inserted new data, pages are allocated. There are eight data pages in an extent. So as soon as the eight pages are consumed, it allocates a new extent with data pages.

answer Dec 29, 2013 by Neeraj Pandey
...