Parallelism in SQL Server Execution Plan

(Ahmad Yaseen) I know SQL Server can run queries in parallel, but how can I tell that a query uses a parallel execution plan and how can I get information about the number of CPUs used when a query executes in parallel? Check out this tip to learn how.