We have a few stored procedures that do some heavy select into (millions of records at a time).
It has been recommend that we alter the database to a Bulk-logged recovery model during the window in which we perform the bulk operations.
We currently have the database in a Simple recovery model. Based on SQL documentation, both Bulk-Logged and Simple recovery models support high-performance bulk copy operations.
Is there any performance benefit to switch the database from Simple recovery model to Bulk-logged recovery model while we perform the 'select into'?