付録F.23 「LargeAlterPartition2nd.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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


ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

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