Home Forums SQL Server 2008 Working with Oracle Linked Server - OPENQUERY Performance Issue RE: Linked Server - OPENQUERY Performance Issue
SQLBuddy123
One Orange Chip
Points: 28294
More actions
March 28, 2014 at 12:00 pm
#1701264
For loading millions of records, it's better to use SSIS. You'll have good performance benefits.
Linked servers are good for less amount of data.
--
SQLBuddy