Performance Difference in comparing integers and comparing strings
int = int

string = string

select *
from Samples
where SamplesID = 5

select *
from Samples
where Name = 'Shampoo'

select top 100 * from tblScratch where contactsurname = '<TestSurname>' order by NEWID()
select top 100 * from tblScratch where contacttyperef = 1-22 order by NEWID()

Duration 430ms
Reads 902
CPU 203

Duration 136ms
Reads 902
CPU 79