The following query took ~8 mins to execute with a million rows:
INSERT INTO [LinkedServer].[LinkedDatabase].[dbo].[LinkedTable]
SELECT * FROM [LocalDatabase].[dbo].[LocalTable]
However, creating an SSIS package and specifying 'Fast Load', inserting only took 8.3 *seconds*.
Why is SSIS so much faster, and what SQL commands can speed up my query?