Does the Fill Factor setting affect heaps / heap tables with non-clustered indexes?

1 vote

1 answer

632 views

sql-server sql-server-2008-r2 nonclustered-index fill-factor heap

                          I came across this old article on Brent Ozar's blog (written by Kendra Little) regarding Fill Factor: https://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/ 

In it, she briefly mentions that the Fill Factor setting does not affect Heaps.

Does this still apply today, and does she mean only pure heaps that don't even have non-clustered indexes?...or to any heap table regardless if it has non-clustered indexes?

Asked by J.D. (40893 rep)

Sep 17, 2018, 05:06 PM
Last activity: Sep 17, 2018, 11:06 PM

Does the Fill Factor setting affect heaps / heap tables with non-clustered indexes?

Related Questions