All Questions
Tagged with fill-factor sql-server-2008-r2
5 questions
1
vote
1
answer
150
views
Can I change Fill Factor option for our database server?
I have a production database for ERP which has clustered and non clustered indexes. Some other tables have index type as heap and i don't understand what does heap means. Every month i have a job run ...
- 101
1
vote
1
answer
612
views
Does the Fill Factor setting affect heaps / heap tables with non-clustered indexes?
I came across this old article on Brent Ozar's blog (written by Kendra Little) regarding Fill Factor: https://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/
In it, she briefly ...
- 39.5k
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 ...
- 289
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? ...
- 3,068
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 ...
- 3,068