Design question/ideas for .Net Client Server application with deadlocking issue

Do you have a T-SQL question?

If yes, post table/index DDL for further assistance.

Optimization & performance tuning: http://ift.tt/1dBfMua

>The problem is everyone/everything is fighting over this BackgrounTasks table and deadlocking on it as everything is either reading or writing to it all the time.  This model/method scales horribly as more users = more deadlocks.  

Can you post code as well? Thanks.

---

---

---

Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014