-- Process each partition SET @PartitionNumber = 1;
-- Get max partition number SELECT @MaxPartition = MAX(partition_number) FROM sys.partitions WHERE object_id = @ObjectID; sql server 2012 enterprise
EXEC dbo.sp_add_schedule @schedule_name = N'Weekly_Sunday_2AM', @freq_type = 8, @freq_interval = 1, @active_start_time = 20000; -- Process each partition SET @PartitionNumber = 1;
-- Insert sample data INSERT INTO dbo.SalesFact (SaleDate, ProductID, CustomerID, Amount, Quantity) SELECT DATEADD(day, number, '2023-12-31'), (number % 100) + 1, (number % 50) + 1, RAND(CHECKSUM(NEWID())) * 1000, (number % 10) + 1 FROM master..spt_values WHERE type = 'P' AND number < 50000; @freq_type = 8