Post reply

Query about Partition the table & Index

  • February 21, 2008 at 5:04 am

    #119994

    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

  • February 21, 2008 at 9:15 pm

    #780949

    any help on these ?

  • February 21, 2008 at 10:29 pm

    #780956

    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

  • February 22, 2008 at 3:02 am

    #781007

    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"

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply