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 
Ratings:
 1 Answer(s)
  1272  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
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