Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we have same Partition function and Partition Scheme to all the tables in a schema ? Expand / Collapse
Author
Message
Posted Tuesday, January 8, 2013 10:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:06 PM
Points: 236, Visits: 985
Can we use same Partition function and Partition Scheme to all the tables in a schema ?
Post #1404372
Posted Wednesday, January 9, 2013 1:41 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 4,323, Visits: 10,572
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.


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1404598
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse