UPDATE STATISTICS Fot all tables in Database

Here is the sp which update STATISTICS for all table.

EXEC sp_updatestats

Update STATISTICS is necessary to avoid deadlock in database.