What should be our precautions and strategies to avoid a Deadlock in a Database System. We should use clustered index maximum for all types of transaction. The clustered key stored in the same data page so whenever we are updating or deleting data, it saves the data searching time. You should always write UPDATE and … Continue reading Database Design: The Ultimate Strategies to avoid Deadlock