Deadlock view script

SELECT  L.request_session_id AS SPID, 
        DB_NAME(L.resource_database_id) AS DatabaseName,
        O.Name AS LockedObjectName, 
        P.object_id AS LockedObjectId, 
        L.resource_type AS LockedResource, 
        L.request_mode AS LockType,
        ST.text AS SqlStatementText,        
        ES.login_name AS LoginName,
        ES.host_name AS HostName,
        TST.is_user_transaction as IsUserTransaction,
        AT.name as TransactionName,
        CN.auth_scheme as AuthenticationMethod
FROM    sys.dm_tran_locks L
        JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id
        JOIN sys.objects O ON O.object_id = P.object_id
        JOIN sys.dm_exec_sessions ES ON ES.session_id = L.request_session_id
        JOIN sys.dm_tran_session_transactions TST ON ES.session_id = TST.session_id
        JOIN sys.dm_tran_active_transactions AT ON TST.transaction_id = AT.transaction_id
        JOIN sys.dm_exec_connections CN ON CN.session_id = ES.session_id
        CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS ST
WHERE   resource_database_id = db_id()
ORDER BY L.request_session_id

Best Featured articles in C# (2016)

Article 1: Singleton Design Pattern in C#

Article 2: Inversion of Control, Dependency Injection and Service Locator in C#

Article 3: C# 7.0 – Pattern Matching

Article 4: C# 7.0 – Local Functions

Article 5: C# 7.0 – Tuples

Article 6: Top 10 new features of C# 6.0

Article 7: SOLID Design Principles

Article 8: async & await keyword in C#

Article 9: Iterators in C#

Article 10: Difference between IEnumerator and IEnumerable Interface in C#

Article 11: Difference between Boxing and Unboxing in C#

Article 12: C# – Race conditions and how to avoid it ?

Article 13: 10 different Number Pattern Programs in C#

Article 14: Is String a Value Type or a Reference Type in C# ?

Article 15: Difference between Stack and Heap memory in C#

Article 16: Return Multiple values from a function in C#

Article 17: Difference between Covariance and Contravariance in C# Generics

Article 18: REST Design Principles

Article 19: Understanding Garbage Collection

Article 20: Extension Methods in C#

Article 21: Asynchronous programming in C# using Async and Await keyword

Article 22: Threads in C#

Article 23: Tasks in C#

Article 24: Dependency Injection in C#

Article 25: Different ways to start a Task in C#

Original here: http://www.csharpstar.com/best-25-csharp-articles-on-csharpstar-in-2016-worth-reading/