Hi,
I am trying to make better performance in our sql statements. We have problems with som queries that has slow performance. It seems regarding to the sql server estimated execution plan that the problem is implicit conversion.
This is my query;
select abbreviation + CONVERT(varchar(23), beginTimestamp, 121) as partof
from customer
abbreviation is a varchar field
beginTimestamp is a timestamp
and those two fields I wan't to concatenate in to one field.
In estimated execution plan I got a warning that says: type conversion in expression (CONVERT (varchar(23), beginTimestamp, 121) may affect CardinalityEstimate in query plan choise.
Maybee some one can help me with this!