Highlight Implicit Conversions due to Data Type mismatch
After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...
Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?
I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)
This will be a great feature if RedGate can incorporate it...
Great suggestion! All for it!
Yes this would be very helpful. Just diagnosed a performance issues because of this and wondered, why doesn't SQL Prompt warn about this! I looked into it didn't find the feature but found this.
Simon Barnes commented
Be even better if MS deprecated them :p