@Johan,

Are the filegroups you're talking about part of a "Paritioned Table"?

Rather than storing the large data in the database and if you don't want to use filestream, the simply store the directory/path information of where the files are stored on...

As with AS on a previous problem, the best advice to answering this question is "MUST LOOK EYE!" 😉

Also to point out and speaking from a bit of experience where I made a Phat Phinger mistake... BE VERY VERY CAREFUL WHEN MAKING THE SETTING CHANGE!!!!   If you screw...

What I've found is that, although there is a benefit to having things on SSD, it's trivial compared to the larger problem.  Main Memory (RAM) (comparatively) blows the doors off of...