coolchaitu - Wednesday, January 24, 2018 11:24 PM
Lots more details. Just an INSERT or an INSERT with a SELECT? Statistics? Execution Plan? Structures?
There is no way in the world for someone to give you enough information to begin to troubleshoot your problem when you define the problem as "taking a very long time." It could be anything. You have to provide some information for us to even start to make educated guesses.
"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