FILLFACTOR option
FillFactor is how much free space Microsoft leaves available in the index pages so that if an insert or an update happens, mainly an update, where the data grows, you don’t want those page splits to be within a row. So, FILLFACTOR can reduce your fragmentation. Typically on systems that see a lot of updates... » read more