SELECT TOP 10 SUBSTRING(text,
   (statement_start_offset/2) + 1,
    ((CASE statement_end_offset
          WHEN -1
              THEN DATALENGTH(text)
          ELSE statement_end_offset
      END - statement_start_offset)/2) + 1)
        AS query_text, *
FROM sys.dm_exec_query_stats
    CROSS APPLY sys.dm_exec_sql_text(sql_handle)
    CROSS APPLY sys.dm_exec_text_query_plan
       (plan_handle, statement_start_offset,
        statement_end_offset)
ORDER BY total_worker_time/execution_count DESC;