I understand fill-factor, pages and index structure and I therefor understand why a 100% fill factor is a rare best practice. So why does it default to 0 (or 100% ) by default? Why not 90 or 95?
Is there something I'm missing?
Just throwing out a few suggestions here as to why Microsoft would do this:
This is just guessing here. The only people that can really answer that question accurately is the SQL Server team themselves.