Page splitting on full data pages

If there is not enough room on the data page for the new row, a page split must be performed.

In some cases, page splitting is handled slightly differently.

See “Exceptions to page splitting”.

In Figure 9-3, the page split requires adding a new row to an existing index page, page 1007.

Figure 9-3: Page splitting in an allpages-locked table with a clustered index