jvanderberg (4/19/2010)
Grant Fritchey (4/19/2010)
Another option would be to use a minimally-logged operation such as bcp or BULK INSERT.I'm confused as to how BCP or BULK INSERT would help, considering the data is already in a table.
Perhaps using SSIS would minimally log the transfer? I've avoided using it in the past because I am unsure about the UDF call.
I suspect they won't help as things currently exist. But if you want to change the behavior of the system, you're going to have to change your process. It's really a question of picking and choosing where you make those changes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning