All Questions
3 questions
14
votes
1
answer
2k
views
Behavior of data in indexes based on fill factor
Let's say you have a database where the default fill factor is 20. Whenever data is inserted, does it only create pages filled up to 20%?
From my understanding, when the data is inserted there ...
4
votes
2
answers
403
views
What is the signifigance of a fillfactor of 20?
I have a database for our ticket system in SQL Server express. I was poking around and noticed that a lot of the indexes have a fillfactor set to 20. What is the signifigance of it being set to 20? ...
2
votes
0
answers
93
views
work/cache table issues, heavy inserts with heavy reads
we have a work table that stores availability of products. This table is updated with millions of inserts every night and medium amounts of inserts throughout the day.
during the updates, we delete ...