September 21, 2011 at 9:00 am
Hi,
Greetings of the Day!!!
I have two different servers. I have to write a query to select data from these server's Databases.
I have created Linked Server between them. But I am facing query performance issue.
Is tere any alternative way without using linked server.
Please let me know.
Regards
Brijendra
September 21, 2011 at 9:04 am
Depends on the queries.
The real issue is when you need to join / filter based on data that's in both servers. Otherwise the server can fully optimize the code and render the results at normal speed.
Any specific case?
September 21, 2011 at 9:20 am
You could use OPENROWSET, but yeah, if you are having performance issues it is probably due to joins on tables between servers.
If the remote set of data is relatively small, you could just start by shipping that data to the local server, shove it in a temporary table/variable and then do your query against that.
September 22, 2011 at 3:30 am
Hi,
How can I use OPENROWSET to get data from another server. Can you please provide the sample query for this.
Regards
Brijendra
September 22, 2011 at 3:32 am
Hi,
Actually I want to create a linked server. Please tell me is there any alternative way?
Regards
Brijendra
September 22, 2011 at 5:13 am
another way to do that is to use openrowset or openquery function.
for more details you can follow these links
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply