All Questions
Tagged with fill-factor best-practices
2 questions
10
votes
2
answers
5k
views
Is it okay to have a fill factor of 100 on the clustered index that is on an ID column?
So I have a table with a clustered index on an ID column (which is an auto-increment column) in SQL Server.
Is it okay to have a fill factor of 100 on this since the data will always get written with ...
- 176
9
votes
1
answer
2k
views
Why does the fill factor in SQL Server default to 0 (100%)?
I understand fill-factor, pages and index structure and I therefor understand why a 100% fill factor is a rare best practice. So why does it default to 0 (or 100% ) by default? Why not 90 or 95?
Is ...
- 405