January 16, 2013 at 3:14 pm
Hi Experts,
Can someone give me some high-level direction on how to approach this?
I'm given a task to do these 2 things:
- 1. Separate customers data across multiple filegroups using table partition (based on CustomerID)
- 2. Archive customers data (using table partition if possible) (based on CreatedDate)
I have a very clear idea on how to do either 1 or 2, but not both. Is that even possible to partition on top of partition? If not, what's the best way to approach this?
Thanks,
Thanh
January 17, 2013 at 12:05 am
Thanh Ngay Nguyen (1/16/2013)
I have a very clear idea on how to do either 1 or 2, but not both.
First you need to perform 1st then monthly job/manual intervention will move the data from partitioned table to destination table (partitioned or non- partitioned) , if you know both the step very well then whats the problem ?
Thanh Ngay Nguyen (1/16/2013)
Is that even possible to partition on top of partition?
What is this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 17, 2013 at 12:44 am
Hi,
You can switch partitions if your idea allows this or TRANSFER the partition to other. PLease follow the following url for more details.
http://msdn.microsoft.com/en-us/library/ms142159.aspx
http://msdn.microsoft.com/en-us/library/ms191160(v=sql.105).aspx
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply