Ok, now I see that I was not precise in question. I was asking for ALTER INDEX REBUILD command, not DBCC DBREINDEX. It seems that DBREINDEX uses last set fillfactor from sys.indexes (https://msdn.microsoft.com/en-us/library/ms181671.aspx), but ALTER INDEX uses 0.
Interesting thing is that in Olla's rebuild script manual it says that it will use fillfactor from sys.indexes althought in a script he uses ALTER INDEX where I cannot see any reference to sys.indexes prior to execution...
I checked on test database and indeed ALTER INDEX will use fillfactor from sys.indexes if not specified.
Answers
RIS Plus, LLC
MVP - Business Apps
I'm asking this because alter index help says that the default value for fillindex option is 0. https://msdn.microsoft.com/en-us/library/ms188388.aspx
I checked on test database and indeed ALTER INDEX will use fillfactor from sys.indexes if not specified.