Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query about Partition the table & Index Expand / Collapse
Author
Message
Posted Thursday, February 21, 2008 5:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Thursday, February 21, 2008 9:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2008 1:05 AM
Points: 49, Visits: 493
any help on these ?
Post #458910
Posted Thursday, February 21, 2008 10:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Friday, February 22, 2008 3:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
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 »

Add to briefcase

Permissions Expand / Collapse