• 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