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

Partition including refernce tables and multiple keys Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 1:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Hi All,

We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?



"More Green More Oxygen !! Plant a tree today"
Post #1403472
Posted Monday, January 7, 2013 3:30 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 7,127, Visits: 12,656
Minaz Amin (1/7/2013)
Hi All,

We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?


No. You only designate one partition key but you can have additional unique constraints which you can then refer to by foreign key.

Just curious, why are you planning to partition your table?


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1403895
Posted Monday, January 7, 2013 10:48 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
My table is huge and get lncremented to 10 - 20 GB in a week so we were planning to partition the table on date range weekly and push the the last old data to archive toother DB or tape.



"More Green More Oxygen !! Plant a tree today"
Post #1403971
Posted Monday, January 7, 2013 11:36 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
Minaz Amin (1/7/2013)
Is it possible to have multiple keys as partitons keys?
let me guess it is because "to cover most of the queries" ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1403984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse