What Are Page Splits?

1.	What Are Page Splits?
Answer» When there is not enough room on a page for a new ROW, a SERVER splits the page, ALLOCATES a new page, and moves some rows to the new page. When there is not enough room on a page for a new row, a Server splits the page, allocates a new page, and moves some rows to the new page.

Answer»

When there is not enough room on a page for a new ROW, a SERVER splits the page, ALLOCATES a new page, and moves some rows to the new page.

When there is not enough room on a page for a new row, a Server splits the page, allocates a new page, and moves some rows to the new page.

Discussion