Partition

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Partition

Partitions.

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.

 

 

 

partitiontab

 

 

 

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