Tips for using SQL Server 2017 configuration options (Part 2) Consider changing the ‘fill factor’ option to the appropriate value. The ‘fill factor’ option specifies how full SQL Server 2017 will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows…