fill-factor Archives

Behavior of data in indexes based on fill factor

By adminPosted on September 30, 2022

Question : Let’s say you have a database where the default fill factor is 20. Whenever data is inserted, does […]

By adminPosted on August 20, 2022

Question : Fill factor is concept that works only when creating a new index or when the index is rebuilt. […]

By adminPosted on July 22, 2022

Question : This question already has answers here: Fillfactor is ignored when non-clustered index added (2 answers) How does FILLFACTOR […]

By adminPosted on June 15, 2022

Question : We have a table that will hold records on the 108 order. ╔══════════╦═════╦══════╦══════════════════════════╗ ║ id ║ a ║ […]

By adminPosted on June 6, 2022

Question : I understand fill-factor, pages and index structure and I therefor understand why a 100% fill factor is a […]

By adminPosted on April 6, 2022

Question : I have a test scenario where I have added fill-factor = 90 to a clustered index over a […]

By adminPosted on March 19, 2022

Question : I have rebuilt all indexes in my database setting fill-factor of 95 (5% free space) using a maintenance […]

By adminPosted on February 17, 2022

Question : I have some indexes that I was playing with on my dev server. I set the fill factor […]

By adminPosted on January 15, 2022

Question : I understand that if a PK is a consecutive number, it will fill a page as its maximum […]

By adminPosted on January 4, 2022

Question : After upgrading our database from 9.3.5 to 9.4.1 last night, the server suffers from high CPU spikes. The […]