create partition function [pf_date](int) as range right for values()
create partition scheme [ps_date](int) as partition [pf_date] to ([primary])
create table [T_BigTable]
(
	 [id] bigint identity(1,1) not null
	,[DateTime] int not null
	,[ID1] int not null
	,[ID2] int not null
	,[Count] smallint not null
) on [ps_date]([DateTime])
create index [idx_ID1] on [T_BigTable]([ID1]) on [ps_date]([DateTime])
create index [idx_ID2] on [T_BigTable]([ID2]) on [ps_date]([DateTime])

create table [T_20180620]
(
	 [id] bigint identity(1,1) not null
	,[DateTime] int not null
	,[ID1] int not null
	,[ID2] int not null
	,[Count] smallint not null
) on [ps_date]([DateTime])

alter table [T_20180620] with check add constraint [T_20180620_CK] check ([DateTime] >= cast(datediff(ss,'2000-01-01','2018-06-20 00:00:00')) and [DateTime] <= cast(datediff(ss,'2000-01-01','2018-06-20 23:59:59.997')))