Partition Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Partition Tables

Partition Tables

Rate Topic

Display Mode

Topic Options

Author

Message

vkundar

Posted Monday, January 21, 2013 11:31 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:27 AM
Points: 83, Visits: 414

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

Post #1409801

Jason-299789

Posted Tuesday, January 22, 2013 12:33 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 803, Visits: 2,124

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

Post #1409831

« Prev Topic | Next Topic »

Permissions