Two minor partition gotchas on partition extent sizing and on the number of partitions in an interval partitioned.
First – old news – note that initial extent size for partitioned tables changed in 22.214.171.124. 872 more words
When split a partition of a reference parent table, the compression attribute “compress for OLTP” is not inherited by child partitions. Instead,it changes into “compress fo BASIC’ by default. 730 more words
HI …. Today I will write in very wonderful topic SQL Server Partitioning and my post will be as Repository for the beginner and for Expert because I will cover the main and most important point and the most cases can be happened by Partitioning , Partitioning Is big story with big history and no one can cover avery thing on it but i will do my best to cover the most important point in Table Partitioning. 874 more words