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

I 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 me an example of a simple query and he was wondering why the query…

2