> My guess is that the main performance gain comes from inserting into a table that doesn't require checks against constraints My guess would it's because inse

> My guess is that the main performance gain comes from inserting into a table that doesn't require checks against constraints My guess would it's because inserting into table variables isn't logged; doubt it has anything to do with constraints. This turns all those individual statements into a single bulk insert, a single larger log operation instead of many small ones.