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!