• Sqlsavy (9/19/2013)


    Drop and re-create clustered index takes 5 minutes in total. So my procedure is completing in just 10 minutes

    Have you tried to do the INSERT with Clustered Index again (i knoe without index it behaved well ) but just you can try.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)