Can we have same Partition function and Partition Scheme to all the tables in a schema ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Can we have same Partition function and...

Can we have same Partition function and Partition Scheme to all the tables in a schema ?

Rate Topic

Display Mode

Topic Options

Author

Message

SQListic

Posted Tuesday, January 08, 2013 10:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:44 PM
Points: 193, Visits: 774

Can we use same Partition function and Partition Scheme to all the tables in a schema ?

Post #1404372

spaghettidba

Posted Wednesday, January 09, 2013 1:41 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 4,804, Visits: 8,091

You can. Whether it's a good idea or not, only you can tell that.
Partitioning is something that must be tested thoroughly before implementing.
If the partitioning key is not used frequently in your queries, the overall performance could get worse than what you get on the non-partitioned tables.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1404598

« Prev Topic | Next Topic »

Permissions