New Transact SQL Video Tutorial: Part 1 - Intro to Query Plans an d the Plan Cache

Part 1 - Intro to Query Plans and the Plan Cache - view details

A query plan is a set of steps used in SQL to access or audit information in your database. In this 6-part video series we will be taking a look at how SQL Server works with plans and how it caches plans. By the end of this series you will be able to troubleshoot problems with plan cache ( formerly known as the buffer cache) performance and be able to reuse existing execution plans. Scott Whigham starts off the series with the essential introduction to query plans and the plan cache, as well as demonstrates how to begin working in the plan cache in SQL Server. Scott's SQL file is included with your download!

Highlights from this video:

• How SQL Server interprets queries
• Queries in ShowPlan XML
• How to eliminate/dump the plan cache
• FREEPROCCACHE
• Viewing the cached plans
• Adhoc plans vs Prepared plans
  

and much more

---

• Source: http://www.LearnTransactSQL.com
• Category: Index Design, Plan Guides, Execution Plans and Query Plans for SQL Server: Performance Tuning Your Queries
• Skill Level: 300 (Intermediate)
• Length: 10:30 (9.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: plan, plan guide, cache, queries, query, adhoc, prepared, xml, buffer cache,