New Transact SQL Video Tutorial: Part 3 - Working with Prepared Plans

Part 3 - Working with Prepared Plans - view details

In this third video in the series, we will continue working with the case when you have two different parameterized values in your queries. Does this result in multiple Prepared plans or just one Prepared plan?Will SQL be able to re-use or will it have to create a new plan? SQL files included in the download.

Highlights from this video:

• Viewing how Adhoc references the Prepared Queries
• When does SQL Server have to come up with a new Prepared plan?
• Implicit datatype conversion and efficiency
  
• Various techniques for Dynamic SQL and Prepared Plan
  

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: 12:45 (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, prepared, plan, query, cache, parameter,