http://www.sqlservercentral.com/Articles tagged Other, Performance Tuning and Scaling posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The SQL Server 2000 Query Optimizer is one of the more complicated things that a SQL Server DBA deals with. For most of us, we just let it work and do not give it a second thought. But when a crisis occurred, Andy and Steve had to dive in to learn a few more things about it. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/realworldqueryplans/1925/2005/06/09http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/realworldqueryplans/1925/