use tempdb;
go

create partition function pf(int) as range for values (0, 10, 50, 100);
create partition scheme ps as partition pf all to ([PRIMARY]);
create table t (a int, b int, c int, dummy char(8000) null) on ps(b);

insert into t (a, b, c)
select top (1000) 1, 0, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 1, 10, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 1, 50, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 1, 100, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 2, 0, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 2, 10, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 2, 50, row_number() over (order by 1/0) from master.dbo.spt_values
union all
select top (1000) 2, 100, row_number() over (order by 1/0) from master.dbo.spt_values;

create index ix on t(a, b) include (c, dummy) on ps(b)
create index ix2 on t(a, b) include (c, dummy) on [primary]
go

set statistics io, time on

declare @c int;

select @c = count(*) from t with (index = ix) where a > 0 and b in (0, 100) and c = 50;
select @c = count(*) from t with (index = ix2) where a > 0 and b in (0, 100) and c = 50;

set statistics io, time off
go

drop table t;
drop partition scheme ps;
drop partition function pf;
go