Partitioning column value range based on master table field?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Muhammad Shujaat... » Partitioning column value range based on...

Partitioning column value range based on master table field?

Rate Topic

Display Mode

Topic Options

Author

Message

bijs

Posted Monday, May 24, 2010 1:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 26, 2012 6:42 AM
Points: 6, Visits: 52

I want to partition my detail table (SQL Server 2008) based on a date field (monthly data i want to partition). But the issue is i don't have a date field in the detail table, but only one int field which is a reference key to the master table which has the actual date field. So basically the detail table has integer values which i need to partition. See the structure below.
Master Table
MKey, Month
1 '1/1/2010'
2 '2/2/2010'
4 '3/3/2010'
8 '4/4/2010'

Note : The value of MKey may not in the sequence as it's an identity column.
Detail Table
Mkey, Other columns
1,--
://millions of records
1,--
2.--
:
2,--
4,--
:
4,--
8--
:

please help to partition the detail table based on month, ie (Mkey column). Or suggest some workarounds. (basically i need to partition all the unique MKey values in the detail table)

Thanks in advance!

Post #926649

« Prev Topic | Next Topic »

Permissions