In my earlier articles of the series, I talked about what
partitioning is in SQL Server; the different kinds of partitioning options,
why and when we should go for partitioning and the benefits partition
table/index provides. Then I talked about the different
partitioning concepts like partition function, partition scheme, choosing
partitioning columns and creating a partition on a table or an index. We also
learned about partitioned index and how an index is aligned and storage aligned
with the base table partitioning.
In this article of the series, I am going to provide a step-by-step guide on
creating a partition table/index. For more information click here.
No comments:
Post a Comment