Often SQL developers encounter a strange behavior of the query optimizer where an index scan is performed rather than an index seek when querying a column with a fixed value. This article explains how implicit conversions affect SQL query performance and cause the query optimizer to perform an index scan instead of index seek while searching for a specific value.