Why am I getting an implicit conversion of Int / Smallint to Varchar, and is it really impacting Cardinality Estimates?

All we need is an easy explanation of the problem, so here it is. I'm trying to trouble shoot a slow performing query using Show Plan Analysis (SSMS) on the…

Continue ReadingWhy am I getting an implicit conversion of Int / Smallint to Varchar, and is it really impacting Cardinality Estimates?