How MS SQL Server gets the most time-consuming first-n T-SQL statements-

--get the most time-consuming first-n T-SQL statements  --for SQL SERVER 2005 and later  --assigning an initial value of N toDeclare @n int Set @n= -     ; withMaco as   (         Select Top(@n) plan_handle,sum(Total_worker_time) asTotal_worker_time,sum(Execution_count) asExecution_count,Count(1) asSql_count fromSys.dm_exec_query_statsGroup  byplan_handleOrder  by sum(Total_worker_time)desc  )  SelectT.text, A.total_worker_time, A.execution_count, A.sql_count fromMaco a Crossapply Sys.dm_exec_sql_text (plan_handle) T/*The resulting format is as follows text Total_worker_time execution_count sql_count------------------------------------------------ ----content slightly*/