Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked server extremely slow performance
Message
From
14/11/2006 15:16:38
David Frankenbach
Austin, Texas, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Linked server extremely slow performance
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01169610
Message ID:
01169621
Views:
9
Sergey,

>How long takes
>execute(@CMD)
>
?

From SQL_A only 2 seconds which is the same as when run from SQL_B. So if the insert is taking that freaking long let me check if there is some column incompatibility between the #temp and the result set....
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform