Dealing with varying fill factors in a SQL Server 2014 environment I've recently become a DBA of sorts for our company's ERP system. I've been making small changes to the server &amp; improvements have been steady. One area I'm concerned with is the index fill factor. I found a YouTube video Brent Ozar did on defragmenting &amp; fill factor of indexes which was most insightful. All my fill factors are currently 100%, but I know that this isn't good for all my indexes. I found this article/script about determining a better fill factor for certain indexes. If this article is still applicable, this brings me to my question:

I'm using the Ola Hallengren scripts to help keep my indexes tidy, but I don't see a way to leave the current fill factor alone. It will rebuild/etc with either the system setting or the specified one but not the current one if it is different.

Does anyone have suggestions/practices they use if an index needs to be rebuild with a specific/different fill factor?
I'm not sure why you think those are the only options. 

If you look in IndexOptimize, the @FillFactor variable is passed in as NULL by default.

The command that appends Fill Factor looks like this:

IF @FillFactor IS NOT NULL AND @CurrentIsPartition = 0 AND @CurrentIndexType IN(1,2,3,4) 
SET @CurrentCommand13 = @CurrentCommand13 + ', FILLFACTOR = ' 
+ CAST(@FillFactor AS nvarchar)


If you leave it NULL, the index will get rebuilt at its current Fill Factor. 

Your only task would be to remove any Fill Factor hints from the Agent jobs, etc.