Linked servers and performance impact: Direction matters!

Posted by Linchi Shea on SQL Blog See other posts from SQL Blog or by Linchi Shea
Published on Wed, 01 Dec 2010 04:31:00 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 482

When you have some data on a SQL Server instance (say SQL01) and you want to move the data to another SQL Server instance (say SQL02) through openquery(), you can either push the data from SQL01, or pull the data from SQL02. To push the data, you can run a SQL script like the following on SQL01, which is the source server: -- The push script -- Run this on SQL01 use testDB go insert openquery(SQL02, 'select * from testDB.dbo.target_table') select * from source_table; To pull the data, you can run...(read more)

© SQL Blog or respective owner

Related posts about best practices

Related posts about Linked server