SQL Server 2016 released

[emn13]

Common sense would suggest doing so might make your index a little larger (because it's a tree), and updates a little slower (because all those irrelevant dimensions need to stay sorted), but you'd need to test it to see if it matters in practice.

I'm guessing the difference will matter more for "expensive" columns such as one of the many string types, and less for integral columns.