Try this thread, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42033 But, its always good to have all the servers running with same collation.
you may find the book, [Dissecting SQL Server Execution Plans] by Grant Fritchey...
Hi,Please try this and let me know if it helps. SELECT *FROM (SELECT M.*, C.ChildID, C.DateStamp, C.Description FROM MasterTable MINNER JOIN...
Separate names with a comma.