SQL Server - Get all running queries

gistfile1.sql

SELECT SUBSTRING(st.text, ( r.statement_start_offset / 2 ) + 1, 
              ( ( CASE WHEN r.statement_end_offset <= 0
                       THEN DATALENGTH(st.text) 
              ELSE r.statement_end_offset END - 
        r.statement_start_offset ) / 2 ) + 1) AS statement_text ,
		r.session_id,
		r.status,
		r.command,
		r.cpu_time,
		r.total_elapsed_time
FROM   sys.dm_exec_requests r 
       CROSS APPLY sys.dm_exec_sql_text(sql_handle) st;