Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked server extremely slow performance
Message
From
14/11/2006 15:39:54
Sergey Berezniker
New York, 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:
01169630
Views:
8
Good to hear that.

>
>I think that's pointed me in the right direction. 13 of the 22 columns were undergoing some level of type conversion. I've set them all to the same as the source and SP1 is running in about 10 seconds now!
>
>>How long takes
>>execute(@CMD)
>>
?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform