May 24, 2010 at 1:40 am
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!
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy