What is hidden in the query plan?

What are memory grants? How can we see wait statistics for a query? Can we get some warnings if our query is misbehaving? Yes, we can. All those details are now in the query plan. On every SQL Server's new version, Microsoft adds invaluable information to the actual, post-execution query plan. If you can understand it, you can solve many of your performance problems. So, if you need to optimise Transact-SQL queries, come to this session: we will open the query plan, look at its XML content, use Plan Explorer, and analyse some tough queries.