Linked server joining

[razaf]

Have two SQL server A and B.
B has linked A sever.

When tryjng to join two columns in A and B,
servername.dbname.dbo table name format,
Unable to join.

Please advise

[Ifor]

Shall we play Guess the Error Message?

If you are joining on strings there might be different collations:

SQL Server collation introduction with collate SQL casting (sqlshack.com)

[robert_volk]

Joining to a linked server will also likely have extremely bad performance. Depending on the linked server product and driver, you'll likely get row-by-row processing (cursor) access on the remote side, and you'll definitely copy the entire dataset over to the local server. The query optimizer will be unlikely to use any indexes or other optimizations.

[razaf]

So, what will be the ideal way to fetch record from two different server with more than one hundred thousand (lakh) of records?

[robert_volk]

I posted a reply here:

Find match in different server

If this is a follow up to this topic: https://forums.sqlteam.com/t/linked-server-joining/23071/3 It would help to know what column(s) are you JOINing or comparing between the local SQL instance and the remote/linked server. If you only have 80 thousand rows on the linked server, and you're only comparing 1 column, or even up to 4 or 5 columns, it would be most efficient to simply insert that data from the linked server into a temp table on the local server. Index the column(s) in the temp tab…

As we're moving on from the original topic of this post.