MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Optimizing Stored Procedure Performance

Course Summary

When using stored procedures, their performance is dependent on creating the optimal plan for the execution environment and making sure that it remains cached. This comprehensive course will show you all of that and more, and is applicable to SQL Server developers and anyone responsible for ensuring performance of stored procedures, from SQL Server 2005 onward.


  • +

    Course Syllabus

    Introduction
    - 21m 19s

    —Introduction 1m 51s
    —This Course 2m 35s
    —What Does Optimizing Stored Procedure Performance Mean? 2m 49s
    —Does This Sound Familiar? 2m 11s
    —What Does Optimizing Stored Procedure Performance NOT Mean? 3m 46s
    —Why This Course Is Relevant 3m 11s
    —Course Focus and Structure (1) 2m 9s
    —Course Focus and Structure (2) 2m 44s
    Why Use Stored Procedures?
    - 27m 4s

    —Overview 2m 4s
    —Different Ways to Execute SQL Statements 2m 25s
    —Some Statements Can Be Cached for Reuse (1) 1m 45s
    —Some Statements Can Be Cached for Reuse (2) 3m 43s
    —Version-Specific Plan Caching Whitepapers 1m 26s
    —Reducing Plan Cache Pollution 4m 32s
    —Understanding sp_executesql 2m 51s
    —Stored Procedures / sp_executesql and the Cache 2m 39s
    —Parameter Sniffing 2m 1s
    —Summary: Why Use Stored Procedures? 3m 34s
    Creation, Compilation, and Invalidation Section 1
    - 1h 8m
    Creation, Compilation, and Invalidation Section 2
    - 53m 29s
    Optimization and Recompilation Section 1
    - 55m 44s
    Optimization and Recompilation Section 2
    - 51m 43s
    Optimization and Recompilation Section 3
    - 1h 8m
    Optimization and Recompilation Section 4
    - 1h 2m
    Other Concerns and Considerations
    - 23m 17s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top