Tuesday, 28 May 2019

Find Currently Running Query in SQL Server

SELECT sqltext.TEXT, req.session_id, req.status, req.start_time, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

No comments:

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...