From BOL:

REMOTE cannot be used when one of the values being compared in the join predicate is cast to a different collation using the COLLATE clause.

The query fails only...

Thank you. You added a sparkle to my day!

As I tried to 'cheat' and learn, I looked up the new-to-me REMOTE-join hint and I read Aaron Bertrand's article [1] on...

[/edit] removed silly reply 😐

[/edit2] I think your position logic is faulty; position[0] is 3 (not 0), position[-3] is 0 so the answer is correct but your logic states position[-2]....

• This reply was modified 1 year, 9 months ago by  fschreuder.
• This reply was modified 1 year, 9 months ago by  fschreuder.

Must admit I only skimmed your article skeptically and was pleasantly surprised with it. Great overview of how and why you should script "by the rules". Usefull conventions, great example...

I do! Thank you! 🙂

Very helpful and informative. Thank you!

I need to invest more time studying the program options as some of my ignorant wishes are just a flag away 😉

Personally I use UnxUtils...

Super!

Ad-hoc analysis for the cowboy DBA.

Might I suggest you extend this with Memory Usage History? 🙂

Off course, in my opinion, there is no substitute for a well designed, ...