Sample Header Ad - 728x90

MS SQL Page split confusion

8 votes
1 answer
766 views
I am a bit confused about page splits in MS SQL and I'm looking for a definitive answer. There seem to be two versions of the story: 1 - Fillfactor only affects how full pages are at the time the index is created/rebuilt. Page splits are always 50/50 2 - Fillfactor also affects how pages are split. So if there is 70% fillfactor and a page overflows, it will split 70/30 Thanks a lot
Asked by Mashchax (155 rep)
Nov 15, 2016, 01:06 AM
Last activity: Nov 16, 2016, 11:51 AM