EXEC dbo.sp_add_job @job_name = N'Enterprise_PartitionOptimization', @enabled = 1;
CREATE PARTITION SCHEME ps_DateRange AS PARTITION pf_DateRange ALL TO ([PRIMARY]); sql server 2012 enterprise
Microsoft SQL Server 2012 Enterprise Edition was designed to provide a mission-critical platform for high-scale data warehousing and advanced business intelligence. While it officially reached , it remains in use by organizations that have purchased Extended Security Updates (ESU) . Core Architecture and Features EXEC dbo
-- Create large fact table with partitioning CREATE TABLE dbo.SalesFact ( SaleID INT IDENTITY(1,1), SaleDate DATETIME, ProductID INT, CustomerID INT, Amount DECIMAL(18,2), Quantity INT, CONSTRAINT PK_SalesFact PRIMARY KEY (SaleID, SaleDate) ) ON ps_DateRange(SaleDate); @enabled = 1
-- Error logging (Enterprise: uses compression) CREATE TABLE dbo.ErrorLog ( ErrorID INT IDENTITY(1,1) PRIMARY KEY, ProcedureName NVARCHAR(256), ErrorMessage NVARCHAR(MAX), ErrorDate DATETIME DEFAULT GETDATE() );
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;';
PRINT 'Processing partition ' + CAST(@PartitionNumber AS VARCHAR) + ' of ' + CAST(@MaxPartition AS VARCHAR); EXEC sp_executesql @SQL;