T-SQL speed comparison between LEFT() vs. LIKE operator
I'm creating result paging based on first letter of certain nvarchar column and not the usual one, that usually pages on number of results. And I'm not faced with a challenge whether to filter results using LIKE operator or equality (=) operator. select * from table where name like @firstletter + '%' vs. select * from table where le...