Do not break your indexes — SARGability and WHERE clause anti-patterns
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 on SQL Server performance tuning