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 |
|
ws5926
Yak Posting Veteran
88 Posts |
 Posted - 2005-09-20 : 15:38:07
|
| I have a table that's heavily queried and updated. Deletes and inserts are probably less than a half dozen times a year and the system is locked to users at those times. I have three unclustered indexes set at 100% fill factor. Would there be any advantage to reducing the fill factor? It is probably 50/50 split on the #of rows updated and the #of rows queried.Live to ThrowThrow to Live |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-20 : 16:10:01
|
| 100% fill factor is for read-only tables. We typically use 80%.Tara |
 |
|
|
|
|
|
100% Fill Factor. When to use it?