SQL Server: Configure Fill factor for Index and Server Instance

In the previous post, I have explained basic about the SQL Server Fillfactor.

SQL Server: Index Performance Tuning with the Fill Factor

In this post, I am going to share some scripts to configure Fill Factor for Index and SQL Server Instance.

Check the default Fillfactor value for SQL Server Instance:

Change the SQL Server default Fillfactor from (0 or 100) to 80:

Check the Fillfactor value for Indexes:

Create new Index with Fillfactor option:

Alter existing Index to change Fillfactor value:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz