Cross instance / server joins

We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Yes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com

Cross instance / server joins

We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com

Cross instance / server joins

We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com