pramodsingla.com
SQL Server Tuning – Top 10 high memory consuming Queries
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, ( q…