Since this is the first part of this series, I'll give a little background as to what I want to accomplish. At some point, you're going to run into a situation where a query on your SQL Server system is "slow". Slowness is usually ambiguous...
Filed under: JOIN, SQL Server, performance, default, index tuning, nonclustered index, primary key, WHERE, clustered index, foreign key, poor performance, criteria, fast query