Home / server / Questions / 347141
In Process
David Youngberg
Asked: 2012-01-06 14:11:26 +0800 CST

SQL Server Partitioning, best practices for creating partition scheme's and functions

  • 772

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?

sql-server-2008 table-partitioning

1 Answers

  1. 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.

    • 0