use tempdb
go
select substring(@@version,  1 ,  50 )
go
create table #test1 (id1 int, id2 int)

insert #test1
select  0 ,  0 
union all
select  1 ,  0 
union all
select  2 ,  0 
union all
select  3 ,  0 
union all
select  4 ,  0 
union all
select  5 ,  0 
union all
select  6 ,  0 
union all
select  7 ,  0 
union all
select  8 ,  0 
union all
select  9 ,  0 

insert #test1
select t1.id1 *  1000  + t2.id1 *  100  + t3.id1 *  10  + t4.id1, t1.id1 /  8 
from #test1 t1, #test1 t2, #test1 t3, #test1 t4
where t1.id1 *  1000  + t2.id1 *  100  + t3.id1 *  10  + t4.id1 >=  10 

-- select * from #test1
create index index1 on #test1 (id2, id1)
go
set statistics io on

select max(id1) 
from #test1 (index index1)
where id2 =  0 

set statistics io off
go
sp_spaceused '#test1',  1 
go

drop table #test1
go