SQL Server High CPU Consumers by Querying the DMV

select top (50)
st.text as Query,
qs.total_worker_time,
qs.execution_count

from sys.dm_exec_query_stats as qs
cross apply sys.dm_exec_sql_text(qs.sql_handle) as st
order by qs.total_worker_time desc