<< Click to Display Table of Contents >> Navigation: »No topics above this level« Partition |
•Partitioning in SQL Server is now available in Standard edition since SQL Server 2016 SP1.
•Partitioning is more about housekeeping and maintenance than performance tuning.
Partition Information is displayed by
•Details- Show partition information for tables
•Alignment- show partition and statistics alignment for partitioned tables. Identify misaligned indexes and incremental statistics