New Transact SQL Video Tutorial: Part 6 - Working with Plan Guides

Part 6 - Working with Plan Guides - view details

In our final video in this series, Scott will talk about the use of plan guides, a pretty advanced topic in SQL 2005 that helps to create a parameterized version of an Adhoc query. Your instructor will cover how it works, when to use it, proper syntax, and the logic of how plan guides are helpful.

Highlights from this video:

• Statement level parameterization
• What are plan guides?
• Why would I want to use plan guides?
• How to create/delete plan guides
• Query template for creating plan guides
• Where is the plan guide referenced?

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: 400 (Intermediate - Advanced)
• Length: 15:15 (14.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, parameter, parameterized, parameterization, template