Problem Statement: Script to find top 10 high memory consuming Queries. Solution: SELECT TOP 10 Object_name(qt.objectid) AS ‘SP Name’, Substring(qt.text, ( qs.statement_start_offset / 2 ) + 1, ( ( CASE qs.statement_end_offset WHEN -1 THEN Datalength(qt.text) ELSE qs.statement_end_offset END[…]
Read more