Quite an interesting but crucial post up there on Sans SQL blog.
The post explains that Implicit conversions in SQL Server could actually trigger a deadlock. And there are definitions for each important term (such as deadlock, implicit conversion, etc.) with an example.
I believe this post would be useful for those who work extensively on SQL Server.