Displaying the FillFactor

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

Neither - fill factor is defined for each index. If you are looking at the fill factor for the clustered index, then you are looking at the table.

To find the fill factor for the indexes:

SELECT * FROM sys.indexes;

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll