RE: Inner joining different servers

RE: Inner joining different servers

 

  

Sounds scary :)

Sounds better to DTS the table I need and just do a query from that.
Sounds less painful.

Thanks,

MG

-----Original Message-----
From: Smith Dano
[mailto:mssqldba-ezmlmshield-x65384294.[Email address protected]
Sent: Monday, February 26, 2007 2:45 PM
To: LazyDBA Discussion
Subject: RE: Inner joining different servers

Might I recommend a bit more on this.

Joining via linked-servers to the production system is not a good idea
[in most environments], be carefull.

Perhaps...
On production, select the KEYS only from the tables in question to
another [temporary in nature - but real table] ProdKeys.
Then, from the other server, join on the ProdKeys table, and you will
not get a screaming DBA in your office - wondering why you are causing
timeouts in all the applications.

Why KEYS only... That's all you need to do the left-join to see what is
missing.
Add more columns later, when you need them.

There are tons of variations on this, but the KEY is, don't' join to
prod tables via linked-servers.

Dano



-----Original Message-----
From: Swasey Steve D CTR 554 ELSG/FNF
[mailto:mssqldba-ezmlmshield-x70449308.[Email address protected]
Sent: Monday, February 26, 2007 3:50 PM
To: LazyDBA Discussion
Subject: RE: Inner joining different servers
Importance: Low

Marty:

If I understand you right, you want to create a query that uses tables
on different servers?

That shouldn't be any problem. Just create linked servers and you can
then create a query on one server that "queries" any of its linked
servers.

Steve


-----Original Message-----
From: Marty Galvan
[mailto:mssqldba-ezmlmshield-x20370228.[Email address protected]
Sent: Monday, February 26, 2007 3:46 PM
To: LazyDBA Discussion
Subject: Inner joining different servers

Is it possible to inner join servers on a query? I want to check one
server that is used for web orders to make sure they are getting
imported into our business system. I want to write a query and do a
check to see if they got moved over. Is this possible?

Thanks,

Marty Galvan
DB/EDI Admin
Making Memories
[Email address protected] <mailto:[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page