Tips to resolve deadlock issues in SQL Server
Deadlocks are sometimes difficult to fix, some of the activities are required as reactive action but some should be done off business hours.
Example:
Move big tables to separate file group to allow parallel write
Adding missing indexes
Removing unused indexes
#shorts