Earlier articles of this series discussed what partitioning in SQL Server is;
the different
kinds of partitioning options, why and when we should go for partitioning
and the benefits a partitioned table/index provides. Then I talked about different
partitioning concepts like partition function, partition scheme, guidelines
on choosing a partitioning column and creating a partition on table or index. We
also learned about partitioned
index and how an index is aligned and storage aligned with the base table
partitioning, with an example.
This article provides you the steps and guidance needed to manage a sliding
window scenario, with an example. For more information, click here.
No comments:
Post a Comment