mayur birari (3/6/2013)
Thanks for the quick reply. What I meant to say is I was able to produce deadlocks even with the indexed tvps.
There is guarantee it will remove them. If you have two procs that acces the same resources in a different order, both in a transaction, nothing is going to save you. All I am saying is that having a clustered index on the table type will reduce deadlocks in some situations when compared to an equivalent setup minus the clustered index.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato