Cacher is the code snippet organizer for pro developers

SELECT TOP 10
    SUBSTRING(b.text, (a.statement_start_offset / 2) + 1,
              ((CASE statement_end_offset
                  WHEN -1 THEN DATALENGTH(b.text)
                  ELSE a.statement_end_offset
                END - a.statement_start_offset) / 2) + 1) AS statement_text,
    c.query_plan, total_worker_time AS CPU_time
FROM
    sys.dm_exec_query_stats a
    CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) AS b
    CROSS APPLY sys.dm_exec_query_plan(a.plan_handle) AS c
ORDER BY
    total_worker_time DESC;