• 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

3 views0 comments

Recent Posts

See All

Standardise database sizes and automation

The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set standard sizes for our data and log files - plus standard sizes

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

Autoclose and autoshrink - set them to off

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose and/or autoshrink. If so, you should change these settings as p