Answer
Page splitting happens when SQL inserts rows into a full page. It increases fragmentation. Fill Factor leaves free space to reduce page splits.
Quick Answer
Page splitting happens when a new row is inserted into a full index page — SQL Server splits the page into two half-full pages, causing fragmentation. Fill Factor sets how full pages are when an index is built (e.g., 80% means 20% room to grow). Lower fill factor = less splitting but larger index size.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ