付録F.17 「LargeCreatePartition.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

CREATE PARTITION FUNCTION netmdm_monitoring_security_pf (datetime)
AS RANGE RIGHT FOR VALUES (
'20110101​','20110102​','20110103​','20110104​','20110105​','20110106​'
,'20110107​','20110108​','20110109​','20110110​','20110111​','20110112​'
,'20110113​','20110114​','20110115​','20110116​','20110117​','20110118​'
,'20110119​','20110120​','20110121​','20110122​','20110123​','20110124​'
,'20110125​','20110126​','20110127​','20110128​','20110129​','20110130​'
,'20110131​'
,'20110201​','20110202​','20110203​','20110204​','20110205​','20110206​'
,'20110207​','20110208​','20110209​','20110210​','20110211​','20110212​'
,'20110213​','20110214​','20110215​','20110216​','20110217​','20110218​'
,'20110219​','20110220​','20110221​','20110222​','20110223​','20110224​'
,'20110225​','20110226​','20110227​','20110228​'
,'20110301​','20110302​','20110303​','20110304​','20110305​','20110306​'
,'20110307​','20110308​','20110309​','20110310​','20110311​','20110312​'
,'20110313​','20110314​','20110315​','20110316​','20110317​','20110318​'
,'20110319​','20110320​','20110321​','20110322​','20110323​','20110324​'
,'20110325​','20110326​','20110327​','20110328​','20110329​','20110330​'
,'20110331​'
,'20110401​','20110402​','20110403​','20110404​','20110405​','20110406​'
,'20110407​','20110408​','20110409​','20110410​','20110411​','20110412​'
,'20110413​','20110414​','20110415​','20110416​','20110417​','20110418​'
,'20110419​','20110420​','20110421​','20110422​','20110423​','20110424​'
,'20110425​','20110426​','20110427​','20110428​','20110429​','20110430​'
,'20110501​','20110502​','20110503​','20110504​','20110505​','20110506​'
,'20110507​','20110508​','20110509​','20110510​','20110511​','20110512​'
,'20110513​','20110514​','20110515​','20110516​','20110517​','20110518​'
,'20110519​','20110520​','20110521​','20110522​','20110523​','20110524​'
,'20110525​','20110526​','20110527​','20110528​','20110529​','20110530​'
,'20110531​'
,'20110601​','20110602​','20110603​','20110604​','20110605​','20110606​'
,'20110607​','20110608​','20110609​','20110610​','20110611​','20110612​'
,'20110613​','20110614​','20110615​','20110616​','20110617​','20110618​'
,'20110619​','20110620​','20110621​','20110622​','20110623​','20110624​'
,'20110625​','20110626​','20110627​','20110628​','20110629​','20110630​'
)
GO

CREATE PARTITION SCHEME netmdm_monitoring_security_ps AS PARTITION
netmdm_monitoring_security_pf TO (
[netmdm_moni_seg]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
)
GO