Inner join Vs Cross Apply

Follow the below links

http://stackoverflow.com/questions/1139160/when-should-i-use-cross-apply-over-inner-join

http://technet.microsoft.com/en-us/library/ms175156.aspx

http://explainextended.com/2009/07/16/inner-join-vs-cross-apply/
 

How to Find Currently Running Query in SQL Server and Killing the session

The below query returns currently running query in SQL Server

Session Query

SELECT sqltext.TEXT,
req.session_id,
req.status,
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
where DB_NAME(req.database_id) = 'northwind'

Kill the session

KILL [session_id] (get the session id from the above query)

Example

Kill 82