Watch Out Pt 1 - Ensure you utilise appropriate data types and use explicit CAST/CONVERT in queries

Watch Out Pt 1 - Ensure you utilise appropriate data types and use explicit CAST/CONVERT in querieshttp://blogs.technet.com/b/sqlman/archive/2007/09/22/watch-out-pt-1-ensure-you-utilise-appropriate-data-types-and-use-explicit-cast-convert-in-queries.aspxI will use the title of "Watch Out" to write about things I see customers implement "incorrectly" or not according to best practices. During a delivery of the SQL Server 2005 Performance Tuning and Optimisation course one of the attendees showed meen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)