Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ITTrucker
Yak Posting Veteran
64 Posts |
 Posted - 2012-04-25 : 12:11:54
|
| Is there any reason to not link 2 SQL servers together?We have one SQL Server 2005 running Sharepoint and ReportServer databases, and on another server we have SQL Server 2008 with our main management software.I'm planning on to run sp_addlinkedserver on the 2005 server so I can access our employee table in the 2008 server to update some Sharepoint lists.Other than being able to query the remote tables, it doesn't look like it will do anything else, but just wanted to make sure it won't cause any issues.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-25 : 13:06:11
|
| Double hop would be a concern . Is this going to be only a read purpose linked server ?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-25 : 13:21:15
|
| Avoid joining local tables to linked server tables, this will cause excess network traffic and can run verrrrrrry slowly. It's better to pull the data from the linked server into a temp table and join to that. |
|
|
|
ITTrucker
Yak Posting Veteran
64 Posts |
Posted - 2012-04-25 : 13:28:50
|
| Correct, I just need to grab some data from 2-3 tables on the remote server. Would not want any updating to happen across the servers, just some select queries. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-26 : 03:58:15
|
| I set up a link once between servers in UK and Malta and it worked great. No joins across the wire but the link was used constantly, several times a second without a hitch. Servers in the same room should be no problem at all...but you do have to make sure that downtime is handled gracefully.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
|
|
|
Negatives with Linked Servers?