May 25, 2010 at 5:59 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!
May 25, 2010 at 10:21 am
Please post in the 2008 forum. This forum is for 7 and 2000, which don't have partitioning. Thanks.
May 25, 2010 at 11:50 pm
My apologies and thanks for notifying it.
How to remove this post from here?
May 26, 2010 at 1:32 am
Thread continues here - http://www.sqlservercentral.com/Forums/Topic927956-360-1.aspx
No further replies to this thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply