Does Page Compression make Index Fragmentation practically irrelevant?
@JeffModen, I'm picking on you specifically, but anyone else with any insights or links to blog posts or videos on this topic would be appreciated.
I'm thinking it doesn't have any impact. It just puts more rows into a page.
You could argue less pages, therefore less fragmentation. But there is still fragmentation.
Curious to see what others think...