Blog Post

Azure Database Support Blog
3 MIN READ

Performance degradation due to implicit conversion

Thamires_Lemes's avatar
Thamires_Lemes
Icon for Microsoft rankMicrosoft
Sep 17, 2021
Implicit conversion is a common cause of performance degradation. It happens when a client/application runs a query in which a column is compared to a parameter with a data type that precedes the c...
Updated Sep 17, 2021
Version 2.0
Lazario1966's avatar
Lazario1966
Copper Contributor
Apr 09, 2023

Great article. I am fighton with implícit conversiones for a long Time. If java aplicacation sends number for a varchar I know that Sql converts to nvarchar and consume processor.

Can I chance datatype of column yo nvarchar to avoid implícit conversion?