New Transact SQL Video Tutorial: Part 4 - Using Parameterization with the Plan Cache

Part 4 - Using Parameterization with the Plan Cache - view details

Continued in this fourth video in the series, Scott will talk more about sp_executesql, forced parameterization, and the situations in which simple parameterization does not occur.

Highlights from this video:

• Examples of when plan re-use does not occur with adhoc queries
  
• About forced parameterization
  
• Using sp_executesql to create a Prepared plan instead of an Adhoc plan
  
• What is the best tool to ensure plan reuse?

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: 12:15 (10.5MB)
• 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: adhoc, plan, query, cache, parameter, parameterization, parameterized, queries, forced, simple, sp_executesql