Issue with UNION and columns with mismatched data types

Estimated data size as a result of implicit conversions can make a huge difference in the execution plan. SentryOne Plan Explorer lets you spot it early.