付録F.9 「AlterPartition.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0009]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20110901​')
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0010]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20111001​')
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0011]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20111101​')
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0012]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20111201​')
GO