Performance impacts of page splitting

Page splits are expensive operations. In addition to the actual work of moving rows, allocating pages, and logging the operations, the cost is increased by:

When you create a clustered index for a table that will grow over time, you may want to use fillfactor to leave room on data pages and index pages. This reduces the number of page splits for a time.

See “Choosing space management properties for indexes”.