Identify Most Resource Intensive Queries - SQL

During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. In this quick video we will learn to identify those queries which are resource intensive.