How To analyze T-SQL code?

Analyze T-SQL code using the following functions:

SET STATISTICS TIME ON 

-- query here 

SET STATISTICS TIME OFF 

In Management Studio Messages tab, you will see the number of milliseconds taken by each step in your query.