Evgeny Garaev (9/18/2012)

---

Percentage is very low for that sample data, it will likely never return any row. Change the query like that to be fair:

create table #Test (ID int primary key);

insert into #Test values (2);

insert into #Test values (1);

select top 1 ID from #Test tablesample (50 percent)

drop table #Test