Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-11-05 : 10:06:06
|
| What does a fill factor of 0% mean?Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-05 : 10:25:14
|
| Thanks for the link but I am aware of that description.The question now is is it ok to set the fill factor for each index to 95% |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-05 : 10:30:10
|
as i understand it's best if you leave it at default.so set it to 95% see how the performance goes and if its better leave it at that...simple trial and error.It's a depends question  Go with the flow & have fun! Else fight the flow  |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-05 : 10:31:17
|
| ok, that is what I am doing, thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-05 : 10:32:59
|
uau... that was helpful of me...  Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
fill factor