I made y’all a SQL Server style Valentine’s day present: a new FREE online training course.
Deadlock graphs are incredibly helpful for figuring out why queries are getting automatically killed off by SQL Server.
What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?
Whenever we have multiple sessions modifying data, things get tricky. When we have a pattern of “check if the data exists and then do a thing,” multiple sessions get even more complicated.