Tools › LIKE performance
Wildcard LIKE performance estimator
LIKE 'Smith%' can seek. LIKE '%Smith' cannot. That is the whole estimator.
Related: LIKE.
Learn it on a real ticket
Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.
Clock in free