Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
What is Extent and Page?

Posted On: 13/10/2013 00:13:55
Extent is a basic unit of storage to provide space for tables. Every extent has 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 new extent with data pages.

While extent is basic unit storage from database point of view, page is a unit of allocation within extent.
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us