Thank you for replies.

Is there a formula to calculate mapping index size for non unique clustered index when it does rebuild?

Perfect, thank you so much!

Thanks guys, i really appreciate your inputs. Definatelly a lot to learn from here.

Excellent information. Thank you for your time.

Thank you so much!

No, what i mean is the number of reads under Reads column in SQL Server Profiler.

When i run SP in SSMS and Include Actual Execution Plan is turn on i...

Thanks a lot for reply's.

Good to know, thank you.

It updates around 40-60 rows and clustered index on LinkShareTransactionID.

Also, how can i distinguish between an actual plan and estimated plan in this case?

I got this plan from profiler by...

Thanks, i added the actual execution plan from Profiler. This plan did not show the use of nonclustered index which i added to the table but it seems that it...

Thank you,

i added index on SiteCode,Purge

and this eliminates deadlocks on parallel threads.

But, i am still not happy since the cpu is more that 1000 and the duration is more...

Thank you, so basically we are merging second index into the first correct?

How about the order of the INCLUDE? Does it matter in this case?

Great! Thank you for reply.