SARGability of WHERE clauses
Why functions in your WHERE clauses stop SQL Server from using your indexes, and how to rewrite your queries to get performance back.
Performance articles
Articles on SQL Server performance, starting with how to write WHERE clauses that let the optimizer use your indexes.