What are the steps to partition a non partitioned or existing table?
Ask by Sumit Kesarwani
Updated 17 Sep 2020
1-Create a partition function.
2-Create a partition scheme.
3- Drop the existing clustered index.
4-Recreate the clustered index on the partition scheme.