Tuesday, July 31, 2007 - Posts

TSQL to identify the transaction with the most locks
31 July 07 07:25 AM | SQL Master | 3 Comments   
SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC Read More...
Performace overhead and resolution when using CLR vs TSQL
31 July 07 01:42 AM | SQL Master | 2 Comments   
Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds Read More...