Solved

Best way to join tables on different servers?

Posted on 2010-11-23
2
525 Views
Last Modified: 2012-05-10
hi what is the best way to join a table from on sql server to another.  Prefixing it with server and database is very slow.  I beleive open rowset is best way but is there any other and what is the syntax?
0
Comment
Question by:hendy1967
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34195294
no other, from what I know...

and if it's slow, it will eventually depend on the join syntax you are doing...
there is no single magic solution to all situations.

you might consider:
* changing the query
* replicating the remote table(s) to the local db
* locate the query/job on the other database
* ...
0
 
LVL 6

Accepted Solution

by:
subhashpunia earned 500 total points
ID: 34195337
Test after loading the remote server's table at local in temp tables and then use the temp tables in joins.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question