November 9, 2009 at 12:42 pm
[font="Arial"]We have an issue with the following:
when joining a varchar defined column in table 'A' to column in a view 'V' which was left in it's underlying table definition of nvarchar we get different results depending on which OS it is run on:
On W2k [5.00.2195 SP4] it hangs, and locks all tables...
On W2003 [SP2] it runs fine.
Adding a CONVERT on either side of the join has the same hanging result...
Adding an RTRIM(A.column) = RTRIM(V.column) works fine...
Replacing the view with the underlying table works works fine as well... (varchar = nvarchar) without conversion or trimming...
Any clues?
PS: We have reproduced the results on 2 pairs of servers...[/font]
November 9, 2009 at 1:50 pm
call MS PSS or check out Microsoft Connect and file a bug report. Windows 2003 SP2 has better memory management than Windows 2000 and this could be a reason
I would also avoid using Windows 2000 for any new servers since it's already out of support and will be out of extended support soon if not already. Windows 2003 is about to get the support boot next year as well.
where i work we haven't deployed a 32 bit SQL server for a long time. all new servers are 64 bit
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply