Sample Header Ad - 728x90

Does Sql Server maintain the free space defined by fillfactor?

0 votes
1 answer
51 views
I'm new to concept of what fillfactor is and why it is used. So far, reading [this article](https://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/) , I've learned that by setting the fillfactor configuration of an index, we specify how much space on each page should remain free, so that whenever a new record needs to be added to a page, there will be some free space for it. My question is that: 1. Is that free space on each page, intended to remain free? I can guess that, that free space is used when an insert happens, but later the database engine, moves data, so that again we have some free space in each page. Is this what happens in a DBMS?
Asked by Shahryar Saljoughi (135 rep)
Aug 29, 2020, 02:47 PM
Last activity: Aug 29, 2020, 03:01 PM