Kevin Kline goes over implicit conversions in SQL Server. He discusses what an implicit conversion is, traps that people fall into with implicit conversions and gives a demo on avoiding implicit conversions.
For more information on SQL Server tuning head to https://www.sentryone.com/blog/author...