GilaMonster (9/26/2013)
Rem70Rem (9/26/2013)
I think this it the creation of the indexes that takes more time.Think? First thing you need to do is time the steps and see for absolute certain which step is taking longer. Otherwise you're guessing and flailing around blindly
Yep! This. Best thing to do is measure and understand what's literally happening with the system rather than guess. When it's running long, what is waiting on, what blocks are occurring, what resources is it using? Answer all these questions and you'll answer, mostly, how to fix it.
"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