Set Statistics Time Examples for Tuning SQL Server Queries

(Rick Dobson) Please provide examples using the set statistics time statement for tuning queries. In addition to a review of the set statistics time statement, present a general framework for assessing the parse, compile, and execution times of any query.