- Repost - originally posted 04-12-2012
SQL Server configuration - default fill factor
The setting of the correct index fill factor is a constant source of debate amongst DBAs. There is a lot of information that you need to know before you set the index fill factor on an individual index. But there is a server wide default index fill factor that you can set to handle the majority of tables. Server Properties -> Database Settings -> Default index fill factor. I usually set this to at least 95%.
This will allow for some growth without page splits, but also not waste too much space.
Its' not perfect, but it is a start