select
st.total_worker_time/st.execution_count as sqlexecTime
,
SUBSTRING(sqltxt.text,st.statement_start_offset/2+1,
(case when st.statement_end_offset=-1 then
LEN(Convert(nvarchar(max),sqltxt.Text))*2
else
st.statement_end_offset end
-st.statement_start_offset)/2) as querySql
from sys.dm_exec_query_stats st
cross apply
sys.dm_exec_sql_text(st.sql_handle) sqltxt
order by
sqlexecTime desc