Query Optimization with Linked Server
Hello Friends, I have faced a problem in SQL queries with Linked server; I just want to share with you all. Let me explain with example as below Say, we have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now the few applications running on SQL 2008 and few on SQL 2000, applications running on SQL 2008 using some of databases which lie on
» Read more