Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
DForck42's user avatar
  • 3,068
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? ...
DForck42's user avatar
  • 3,068
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 ...
ttomsen's user avatar
  • 289