SQL Query Performance

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2011/10/21/when-to-break-down-complex-queries.aspx

http://msdn.microsoft.com/en-us/library/ff647793.aspx

http://www.sqlservercentral.com/stairway/72399/ - indexes

Allow Multipel Processors to be involved in running your stored procedure:

• OPTION (MAXDOP 8)