Home Forums SQL Server 2014 Administration - SQL Server 2014 Using OpenRowset to Insert Data RE: Using OpenRowset to Insert Data
x
SSC-Insane
Points: 23660
More actions
December 5, 2016 at 11:13 am
#1916066
This link has helped me understand strategies for linked servers (and it might be that openquery to remote servers might be impacted also).
http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspx
Bottom line, faster to select from remote servers than insert to remote servers by quite a bit.