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.
MS Sql Server LazyDBA home page