Query about Partition the table & Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Query about Partition the table & Index

Query about Partition the table & Index

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanakumar.Rathinam

Posted Thursday, February 21, 2008 5:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2008 1:05 AM
Points: 49, Visits: 493

Is it possible for partition the existing table rows without altering any existing indexes ?

if i am using the below query, it drop the indexes.
Drop index IX_DOCID on PartionOrder1 with (Move To [YearPS] (DueDate) )

thanks in advance

thanks & regards

Post #458478

Saravanakumar.Rathinam

Posted Thursday, February 21, 2008 9:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2008 1:05 AM
Points: 49, Visits: 493

any help on these ?

Post #458910

Saravanakumar.Rathinam

Posted Thursday, February 21, 2008 10:29 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2008 1:05 AM
Points: 49, Visits: 493

I'm having the existing table around 75million records, which lies in primary file group with contains one clustered and 6 non clustered index columns out of 25 columns in the table. I want to be partition the particular table by month on month with out altering any indexes.

Please guide me if it is possible ?

thanks & regards
Saravanakumar.R

Post #458921

ChiragNS

Posted Friday, February 22, 2008 3:02 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

Hi

There are lots of articles on the web regarding table partitioning sepcially the one by KimberTripp.

http://msdn2.microsoft.com/en-us/library/ms345146.aspx

Dont know whether this is what you require and I dont know too much about this to help you more.

"Keep Trying"

Post #458984

« Prev Topic | Next Topic »

Permissions