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: 478
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
