You can create a partitioned table or index by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql]. The data in partitioned tables and indexes is horizontally divided into units that can be spread ...
THEN 'ALTER TABLE ' + OBJECT_SCHEMA_NAME(pstats.object_id) + '.' + OBJECT_NAME(pstats.object_id) + ' REBUILD PARTITION = ' + CONVERT(VARCHAR(5), pstats.partition ...