PHYData DBA (3/26/2015)

---

Jeff Moden (3/24/2015)

---

As for the padding thing in the BTREE, that's done during an index rebuild using the "WITH PADDING" option. Note that it will not help performance of batch runs that should be doing an index seek with a scan of the leaf level when the start of the scan is determined.

But this still means setting the Fill Factor to something other than 100% or it does nothing really.

Right?

Is there some magic I am missing where Fill Factor can be 100 or 0 but PADDING can be set?

https://technet.microsoft.com/en-us/library/aa258260(v=sql.80).aspx

Maybe there is something wrong with this article, please let me know, but it says that with Padding would cause the intermediate and Leaf Pages to be created with the specified Fill Factor setting. Since there is only one page left free at all times for all settings of Fill Factor I can't explain to others how this would be better for anything.

I trust your opinion a LOT. So some more input on that would be awesome.