I'm implementing partitioning for the first time in SQL Server 2008 R2. I've several large tables that I am partitioning.
My main question is: Should I use the same Partition Scheme and Function for all these tables, or should I create multiple Partition Schemes and Functions?
When I move older data to a different file group, will having separate Schemes and Functions make moving the data easier?
And what are some things that I should consider when making this decision?