[Closed] indexing problem after implicit conversion in sql server 2005

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.

avatar image By Anoop 0 asked Oct 16, 2013 at 02:35 PM
more ▼
(comments are locked)
avatar image SQLkiwi ♦ Oct 25, 2013 at 04:19 AM

The anonymized plan shows nothing useful for us to help you with this issue. Please provide a repro script instead, together with a non-anonymized plan if that will assist us. In general, SQL Server will use a useful index if collations match.

10|10000 characters needed characters left

The question has been closed Oct 25, 2013 at 04:19 AM by SQLkiwi for the following reason:

Problem is not reproducible or outdated

0 answers: sort voted first

We are Moving!


Follow this question



asked: Oct 16, 2013 at 02:35 PM

Seen: 308 times

Last Updated: Oct 25, 2013 at 04:19 AM