configuration parameter SQL fillfactor

11-23-2021 05:05 AM
Occasional Contributor

I want to know more about SQL FillFactor, 

what I know is that SQL server DB consist of Data file (.mdf or .ndf), and data files consist of Extents also each extent have 8 pages, therefore each page takes a number or percent from 0 to 100 to write in it (which is the FillFactor) so i want to know what is the benefit for this if I change it to 50 or 80??

0 Kudos
0 Replies