• 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

Recent Posts

See All

Migrating SSIS packages to AWS

We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise to get these packages running. What we have learnt (so far) is