Hi thanks for the response.

I've now changed the indexes on the database so the primary key is now clustered and the index on the owner is now non-clustered.

I now...

Here is the execution plan for the clear basket sp

Thanks for the tip, I added the index as you suggested and the execution plan shows that it is now using the index.

I also ran the clear basket sp with...

Hi thanks for the response,

Yes I've already grabbed the deadlock trace using the sql profiler this is what lead me to these queries being the culprits. I've attached the deadlock...