付録F.20 「LargeAlterPartition.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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


ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0007]
GO

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