Create and Manage Partitions

The sp_configure option enable semantic paritioning turns on semantic paritioning. Round-robin partitioning is always available, and is unaffected by the value of enable semantic partitioning.

To enable semantic partitioning at your licensed site, enter:
sp_configure ‘enable semantic partitioning’, 1
Enable semantic partitioning to perform commonly used administrative and maintenance operations such as: