Home > DeveloperSection > Interviews > What are the steps to partition a non partitioned or existing table?

Posted on    June-15-2013 4:12 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1243  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    June-15-2013 12:00 AM

1-Create a partition function.

2-Create a partition scheme.

3Drop the existing clustered index.

4-Recreate the clustered index on the partition scheme.

Don't want to miss updates? Please click the below button!

Follow MindStick