I have 2 MS SQL servers one with SQL 2008(machine A) and another with MS SQL 2005 (machine B)
I created a linked server from Machine A to Machine B. Executed a simple query
Select * from [Machine B].Database.Xtable
It took nearly 30 seconds to bring back 496 rows of data.
Similarly created a linked server from machine B to machine A.Executed the simple query
Select * from [Machine A].Database.Xtable
It took less than a second to display the same 496 rows.
Is there any specific setting to be done on MS SQL 2008 to improve the performance.
Any help is appreciated.
View Complete Post