Query optimization techniques in SQL Server [1]: the basics

Query optimization techniques in SQL Server [2]: tips and tricks