Home > DeveloperSection > Interviews > What are Page Splits?

Posted on    March-15-2014 7:14 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1066  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    March-15-2014 12:00 AM

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”.

Don't want to miss updates? Please click the below button!

Follow MindStick