It should be available and incorporated in a decent development and maintenance process.

That being said, I join Phil's experience.

I'm happy to confirm that statement 🙂

Congratulations !

I've been enjoying it for nearly that whole era 🙂

We are using a partition function based on month number and have filegroups per month.

Best ref is the one Steve mentioned.

You can add filegroups as you want.

You need to map...

will there be concurrent activities?

Even this first topic forum reference doesn't have...

I've tested it all to see its effects on our db.

For the rare cases where we still use native backups, we use backup devices for simplicity of the commands.

Actual filenames...

That's why Testing is a must!

Thank you for the remark.

I'll remove it from my signature.

Strange indeed.

Did you replay it ( e.g.using the free PlanExplorer  )

Test  ( disregard )

Indeed.

Fingers crossed

without a doubt: "The Bare Necessities (from The Jungle Book)"

altough not a best practice, dynamic sql will be about the only way to help you out

ref: dos-and-donts-of-dynamic-sql 

btw: Where is the where clause of your query ?