[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Optimize script sql for reduce deadlock

Hello,

Herewith a script batch-load-datas.
How can I optimize this script for reduce deadlock, please?

Thanks

bibi
batch-load-datas.txt
0
bibi92
Asked:
bibi92
2 Solutions
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
please read this http://msdn.microsoft.com/en-us/library/ms189050.aspx

to reduce deadlock at row and database level

hope this helps
0
 
bibi92Author Commented:
Thanks a lot bibi
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now