Using a query through a linked server is giving tremendously reduced performance.
Is part of the problem linking from a SQL 2000 to a SQL 7.0 database?
Are there any other tips out there?
Thanks.
The major difference between 7.0 and 2000 is DRI (declarative referential integrity) so run you code through SQL Server 2000 profiler and if you have indexes run DBCC ShowContig to see if your AIM (index allocation mapping) pages are fragmented. Hope this helps.
No comments:
Post a Comment