Rebuild index and fill factor

Phenno

Does T/SQL rebuild index command with no fillfactor set use fillfactor = 0 or fillfactor set on index or fillfactor set on server?

DenSter

It should use the default value that is set at the server level

DenSter

It should use the default value that is set at the server level

Phenno

Is there a way to check it?

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

Phenno

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.

Phenno

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.