SQL SERVER - Find Currently Running Query - T-SQL

This is the script which I always had in my archive. Following script find out which are the queries running currently on your server. BOOKMARK IT! You will find it very useful and very often.