Resources

Contact Support

Hours

6am-8pm EST (GMT -5)

Open a Case
E: Email Us
P: 416.868.0152

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

Current Date/Time: 2012-05-17 12:49:34
Number of Partitions selected: 12

Change number of partitions:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE PARTITION FUNCTION [function_sample](datetime) AS RANGE RIGHT FOR VALUES (N'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-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'2011-08-01', N'2011-09-01', N'2011-10-01', N'2011-11-01', N'2011-12-01', N'2012-01-01', N'2012-02-01', N'2012-03-01', N'2012-04-01', N'2012-05-01', N'2012-06-01', N'2012-07-01')
CREATE PARTITION SCHEME [scheme_ranged_object_value] AS PARTITION [function_ranged_object_value] ALL TO ([PRIMARY])

COMMIT TRANSACTION

My up.time

Resources

Contact Support

Hours

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