Review the section over SET STATISTICS PROFILE. This command will allow the query to execute as well as return the execution plan.

I also plan on detailing the output over several articles as I feel that the explanation would be too long to fit in a single article. I will start working on a side article that explains the commands in more details and go over some of the "gotchas" you asked for.

Randy