Just wanted to know if there is a DMV through I can able to tell that my workload type is 'ad hoc'? Any help would be appreciated. Thank you.
I have a query to retrieve the Top 10 queries based on total logical reads from the dm_exec_query_stats DMV. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE ...