npranj (12/20/2012)
Would this help?WAITFOR DELAY '00:00:00.05' -- Wait for 5 ms
As in, if you get a deadlock, ignore it and try again, repeat until successful? Sure, I wouldn't call it a solution though.
And also if there are 6 threads spanning 70k records, will table partitioning be of help?
Maybe. Depends how you partition, how the queries are written, what data is needed, what granularity locks are taken, etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability