SQL show running queries
We sometimes need to find out running queries on sql server box. To show running queries using t-sql I use the syntax below
SELECT *We sometimes need to find out running queries on sql server box. To show running queries using t-sql I use the syntax below
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
