Something which may seem basic, but in many SQL statements I analyse for performance optimisation, the same mistakes are recurring. When a WHERE clause is used the actual operator used will influence the query speed. That is not to say, every statement has the option of using the optimal operator.
It's worth keeping in mind the order of the operator , the order starts with the fastest performer.
Republished from http://www.sqlserver-dba.com.