Home Forums SQL Server 2008 SQL Server 2008 - General Query performance change RE: Query performance change
TheSQLGuru
SSC Guru
Points: 134017
More actions
October 25, 2012 at 10:30 am
#1552802
I will also note you are joining on mis-matched datatypes (or doing an unnecessary convert), which is also suboptimal.
Best,Kevin G. BolesSQL Server ConsultantSQL MVP 2007-2012TheSQLGuru on googles mail service