In this video, Scott Fallen shares tips on how to get started with execution plans. He starts out by going over what an execution plan is and why they are important. Then he discusses what happens when SQL Server receives a query, how to create plans and how to read them. He also explains what to look for when you want to optimize your query plans. Scott then walks you through a couple of sample plans using Management Studio as well as Plan Explorer. At the end, he takes you through a list of additional resources you can reference to.
Note: eBook no longer available via Amazon. Email firstname.lastname@example.org if you are still interested in receiving a copy.