• I will also note you are joining on mis-matched datatypes (or doing an unnecessary convert), which is also suboptimal.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service