Rem70Rem (9/26/2013)
If I restart the SQL server just before, the process take a bit more then 1 hour. After a week, the same process takes 2hours. I can't explain why the time of execution is increasing that much.
Rem70Rem (9/26/2013)
I think this it the creation of the indexes that takes more time.
i dont think above two operations are inter related or linked ... sql server doesnt create or rebuild the indexes unless they are set with startup task (even this is also strange option)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)