USE [NETMDM_SAMPLE]
GO
CREATE PARTITION FUNCTION netmdm_monitoring_security_pf (datetime) AS RANGE RIGHT FOR VALUES (
'20110101',
'20110201',
'20110301',
'20110401',
'20110501',
'20110601',
'20110701',
'20110801'
)
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_0002],
[netmdm_moni_dp_0003],
[netmdm_moni_dp_0004],
[netmdm_moni_dp_0005],
[netmdm_moni_dp_0006],
[netmdm_moni_dp_0007],
[netmdm_moni_dp_0008]
)
GO |