What are Page Splits?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 3303

Pages are contained in extent. Every extent will have around eight data pages. But all the eight data pages are not created at once; they are created depending on data demand. So when a page becomes full it creates a new page, this process is called as “Page Split”.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response