Hi even though i have no mismatch of columns,sqlserver still does an implicit conversion.And my collation is SQL_Latin1_General_CP1_CI_AS. This is resulting in full table scan rather than index seek. I have a non clustered index on a column. I have also tried changing the collation to Latin1_General_CI_AS.But there was no difference. Please suggest me code fix to solve this issue.
By Anoop 0 asked Oct 16, 2013 at 02:35 PM
The question has been closed Oct 25, 2013 at 04:19 AM by SQLkiwi for the following reason:
Problem is not reproducible or outdated