I've never had an issue comparing 2 varchars of different lengths, but it might be that comparing a nvarchar to a varchar would have at least a similar problem because...

• This reply was modified 4 days, 8 hours ago by bill.rogers 55030.

Just to take your example a little further, I've found that the same thing can happen with different numeric datatypes.  For example, if one of the datatypes is one of...

This is a good explanation of the contention problems when using sequential keys.  This problem has been a problem with SQL Server since the days of SYBASE.

I've experienced this with...

• This reply was modified 9 months, 3 weeks ago by bill.rogers 55030.
• This reply was modified 9 months, 3 weeks ago by bill.rogers 55030.