up.time - SQL Server Function/Scheme Generator for Table Partitioning

Current Date/Time: 2025-11-28 10:29:56
Number of Partitions selected: 12

Change number of partitions:

23456789101112131415161718192021222324252627282930313233343536

USE [uptime] GO BEGIN TRANSACTION IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_sample') DROP PARTITION SCHEME scheme_sample GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_sample') DROP PARTITION FUNCTION function_sample GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_aggregate') DROP PARTITION SCHEME scheme_aggregate GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_aggregate') DROP PARTITION FUNCTION function_aggregate GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_cpu') DROP PARTITION SCHEME scheme_cpu GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_cpu') DROP PARTITION FUNCTION function_cpu GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_disk') DROP PARTITION SCHEME scheme_disk GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_disk') DROP PARTITION FUNCTION function_disk GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_disk_total') DROP PARTITION SCHEME scheme_disk_total GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_disk_total') DROP PARTITION FUNCTION function_disk_total GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_esx3_workload') DROP PARTITION SCHEME scheme_esx3_workload GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_esx3_workload') DROP PARTITION FUNCTION function_esx3_workload GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_fscap') DROP PARTITION SCHEME scheme_fscap GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_fscap') DROP PARTITION FUNCTION function_fscap GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_lpar_workload') DROP PARTITION SCHEME scheme_lpar_workload GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_lpar_workload') DROP PARTITION FUNCTION function_lpar_workload GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_network') DROP PARTITION SCHEME scheme_network GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_network') DROP PARTITION FUNCTION function_network GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_nrm') DROP PARTITION SCHEME scheme_nrm GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_nrm') DROP PARTITION FUNCTION function_nrm GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_psinfo') DROP PARTITION SCHEME scheme_psinfo GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_psinfo') DROP PARTITION FUNCTION function_psinfo GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_vxvol') DROP PARTITION SCHEME scheme_vxvol GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_vxvol') DROP PARTITION FUNCTION function_vxvol GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_who') DROP PARTITION SCHEME scheme_who GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_who') DROP PARTITION FUNCTION function_who GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_int_data') DROP PARTITION SCHEME scheme_int_data GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_int_data') DROP PARTITION FUNCTION function_int_data GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_decimal_data') DROP PARTITION SCHEME scheme_decimal_data GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_decimal_data') DROP PARTITION FUNCTION function_decimal_data GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_string_data') DROP PARTITION SCHEME scheme_string_data GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_string_data') DROP PARTITION FUNCTION function_string_data GO IF EXISTS (SELECT name FROM sys.PARTITION_SCHEMES WHERE name = 'scheme_ranged_object_value') DROP PARTITION SCHEME scheme_ranged_object_value GO IF EXISTS (SELECT name FROM SYS.PARTITION_FUNCTIONS WHERE name = 'function_ranged_object_value') DROP PARTITION FUNCTION function_ranged_object_value GO CREATE PARTITION FUNCTION [function_sample](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_sample] AS PARTITION [function_sample] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_aggregate](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_aggregate] AS PARTITION [function_aggregate] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_cpu](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_cpu] AS PARTITION [function_cpu] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_disk](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_disk] AS PARTITION [function_disk] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_disk_total](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_disk_total] AS PARTITION [function_disk_total] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_esx3_workload](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_esx3_workload] AS PARTITION [function_esx3_workload] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_fscap](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_fscap] AS PARTITION [function_fscap] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_lpar_workload](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_lpar_workload] AS PARTITION [function_lpar_workload] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_network](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_network] AS PARTITION [function_network] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_nrm](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_nrm] AS PARTITION [function_nrm] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_psinfo](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_psinfo] AS PARTITION [function_psinfo] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_vxvol](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_vxvol] AS PARTITION [function_vxvol] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_who](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_who] AS PARTITION [function_who] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_int_data](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_int_data] AS PARTITION [function_int_data] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_decimal_data](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_decimal_data] AS PARTITION [function_decimal_data] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_string_data](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_string_data] AS PARTITION [function_string_data] ALL TO ([PRIMARY]) CREATE PARTITION FUNCTION [function_ranged_object_value](datetime) AS RANGE RIGHT FOR VALUES (N'2025-02-01', N'2025-03-01', N'2025-04-01', N'2025-05-01', N'2025-06-01', N'2025-07-01', N'2025-08-01', N'2025-09-01', N'2025-10-01', N'2025-11-01', N'2025-12-01', N'2026-01-01') CREATE PARTITION SCHEME [scheme_ranged_object_value] AS PARTITION [function_ranged_object_value] ALL TO ([PRIMARY]) COMMIT TRANSACTION