Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm implementing Partitioning for the first time in SQL Server 2008r2. 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 Scheme's and Functions?

When I move older data to an different file group will having separate Scheme's and Functions make moving the data easier?

And what are some things that should consider when making this decision?

share|improve this question
    
consider posting your question to serverfault's sister site for database-related stuff dba.stackexchange.com –  syneticon-dj Jan 5 '12 at 22:38
    
Thanks, I have posted it there at: dba.stackexchange.com/questions/1023 –  David Youngberg Jan 5 '12 at 23:09
    
You probably mistyped your link - it should be dba.stackexchange.com/questions/10239 –  syneticon-dj Jan 5 '12 at 23:37
add comment

1 Answer

If you have a single schema and function and you alter that to move data around all the tables will be moved in a single shot instead of having to change all of them.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.