The indexing helps as long as you are still only deleting small batches, if you have a rewrite of the stored procedure you could easily send me that would save me some time in rewriting it myself (although it's not a particularly complicated proc).
Loading User Information from Channel 9
Something went wrong getting user information from Channel 9
Loading User Information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
The indexing helps as long as you are still only deleting small batches, if you have a rewrite of the stored procedure you could easily send me that would save me some time in rewriting it myself (although it's not a particularly complicated proc).