Sql Server 2012 | Enterprise ~repack~

IF @ObjectID IS NULL BEGIN RAISERROR('Table not found', 16, 1); RETURN; END;

-- Process each partition SET @PartitionNumber = 1; sql server 2012 enterprise

EXEC dbo.sp_add_jobstep @job_name = N'Enterprise_PartitionOptimization', @step_name = N'Optimize Sales Partition', @command = N'EXEC dbo.Enterprise_OptimizeTablePartitions ''dbo'', ''SalesFact'', ''PAGE'', 4, 5;'; IF @ObjectID IS NULL BEGIN RAISERROR('Table not found',

-- Get max partition number SELECT @MaxPartition = MAX(partition_number) FROM sys.partitions WHERE object_id = @ObjectID; @step_name = N'Optimize Sales Partition'