I would say, use linked server connection but load your data into temp
tables, then do your main query, in this way the impact on the
production environments will be minimal.
-----Original Message-----
From: jason
[mailto:mssqldba-ezmlmshield-x26432083.[Email address protected]
Sent: Tuesday, February 27, 2007 11:04 AM
To: LazyDBA Discussion
Subject: RE: Inner joining different servers
Interesting.
I have on occasion ran queries such as these and have experienced no
discernible performance to cause me concern, in fact i've usually been
rather impressed - although i do understand the relationships and
indexes to use.
Regards
|---------+-------------------------------------------------------->
| | "Smith Dano " |
| | <mssqldba-ezmlmshield-x65384294.[Email address protected]
| | om> |
| | |
| | |
| | Monday February 26, 2007 21:45 |
| | |
|---------+-------------------------------------------------------->
>-----------------------------------------------------------------------
---------------------------------------|
|
|
| To: "LazyDBA
Discussion" <[Email address protected] |
| cc:
|
| 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
This e-mail is being sent to you for your information or at your
request.
The information contained in this e-mail is not warranted as to
completeness or accuracy, nor does it serve as an official record of
your account, which is provided only by your trade confirmation or
client account statement from Prudential Bache Commodities, LLC,
Prudential Bache Securities, LLC or Bache Commodities Limited. Since the
confidentiality of Internet e-mail cannot be guaranteed, please do not
include private or confidential information (such as account numbers) or
instructions requiring your authorization (such as orders or funds
transfers) in your e-mail communication to us.
Prudential Bache Commodities, LLC, Prudential Bache Securities, LLC,
Bache Commodities Limited and Bache Commodities (Hong Kong) Limited are
affiliates of Prudential Financial, Inc., which is headquartered in the
United States. Bache Commodities Limited is authorized and regulated by
the Financial Services Authority.
If you have received this communication in error, please notify the
sender immediately by replying to the message and delete it from your
system. If you do not wish to receive further e-mail from us, please
send an e-mail to do.not.[Email address protected] Thank you.
---------------------------------------------------------------------
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
Disclaimer
http://www.shoprite.co.za/disclaimer.html
MS Sql Server LazyDBA home page