To enable semantic partitioning at your licensed site, enter:
sp_configure ‘enable semantic partitioning’, 1
Round-robin partitioning is always available, and unaffected by the value of enable semantic partitioning.
Enable semantic partitioning to perform commonly used administrative and maintenance operations such as:
Creating and truncating tables – create table, truncate table
Altering tables to change locks or modify schema – alter table
Creating indexes – create index
Updating statistical information – update statistics
Reorganizing table pages to conform to clustered indexes and best use of space – reorg rebuild
