New Transact SQL Video Tutorial: Part 5 - Forced Parameterization vs Simple Parameterization

Part 5 - Forced Parameterization vs Simple Parameterization - view details

In this video tutorial, Scott will discuss your options for using Forced or Simple parameterization in your plan cache as well as go into greater detail about employing forced parameterization.

Highlights from this video:

• Review of forced and simple (auto) parameterization
  
• Two ways to do forced parameterization
• database level
• statement level
• Review of plan reuse for Adhoc and Prepared plans
• How forced parameterization works at the database level
• When to use forced parameterization

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: 09:30 (9.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, prepared, auto,