RonKyle (10/13/2015)
A downside I've seen is that when I adopted this method I had to stop putting my indexes in a different file group because of the restore issues.
I would love to hear more about this. It sounds like we are pretty similar with massive OLAP databases. I'm still keeping my indexes in their own filegroup, but have not ran into any restore issues.