March 26, 2014 at 8:43 am
HI
I need to partition a table with existing data based on a column "ColumnA" which is not part of clustered index. This column is not part of any non clustered index as well. The clustered index is with Primary key.
How do I do it?
thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 26, 2014 at 9:03 am
It is possible only if you will add ColumnA to the clustered index.
March 26, 2014 at 9:09 am
Please don't post the same question several times - it scatters the conversation over several threads.
Original article - http://www.sqlservercentral.com/Forums/Topic1548455-391-1.aspx
March 26, 2014 at 9:12 am
I don't want to change the clustered index as that is on primary key. So another option is i make primary key non clustered and create a clustered index on partitioned column...
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 26, 2014 at 9:14 am
Sorry, I felt i didn't present the question correctly there in another thread. So wanted to avoid the confusion in my original question.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 26, 2014 at 9:15 am
Please don't post multiple threads for the same question, it just wastes people's time as they have to reply in multiple places and makes things hard to follow.
Please can we keep replies in http://www.sqlservercentral.com/Forums/Topic1548455-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply