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, and almost always relates to a persons reference. However, when we hear that something is slow or broken we need to check it out and see what may be the cause. So, my goal is to introduce simple to increasingly complex queries and show you the...
Filed under: JOIN, SQL Server, performance, default, index tuning, nonclustered index, primary key, WHERE, clustered index, foreign key, poor performance, criteria, fast query