January 21, 2013 at 11:31 pm
Hi All,
I need the partition as following:
The current data starts in the Head partition.
Based on a partition function, When data is:
1 month old) moves to 001 partition automatically
2 months old) moves to 002 partition automatically
3 months old) moves to 003 partition automatically
4 months old) moves to 004 partition automatically
5 months old) moves to 005 partition automatically
6 months old) moves to Tail partition automatically. Once in tail partition, it moves to next database
I dont have any idea onpartition and hpw to config except using the wizard to create a range partition but dont knowe how to move across the data between the aprtition? IOs there any dependecies between the FK while moving the data.
Need your input.
Cheers,
Got an idea..share it !!
DBA_Vishal
January 22, 2013 at 12:33 am
read the MS white paper located here http://msdn.microsoft.com/en-us/library/dd578580(v=sql.100).aspx (Page 43) for details on the sliding window concept that it appears you want to introduce.
As for moving the initial data over to the partition simply drop and recreate the clustered index on the table ensuring that the most significant column is also the partitioned column. This will then move the data into the partitions.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply