Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2003-10-21 : 09:23:50
|
| Hi, HOw do we practically resolve a deadlock on real time basis.Thanx |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-21 : 09:50:02
|
The best method is to not have them in the first place.Look in Books Online under "Deadlocks" -> "Resolving" for some best practices.This post reminds me of a very silly joke....A bear walks into a bar and says "I'll have a rum and .....................Coke"The bartender says "Why the long pause ?" to which the bear replies, "I don't know, I've always had them" Damian |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-10-21 : 10:17:41
|
| Ya know, there oughta be a law against this kind of stuff ! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-21 : 12:27:43
|
| You could also enable the deadlock trace flags to determine which queries are having the problem.Tara |
|
|
|
|
|
|
resolving deadlock