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 - Part 2

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. In the second part of this comprehensive course, you'll continue to learn techniques for ensuring that this is applicable to SQL Server developers and anyone who is responsible for ensuring performance of stored procedures, from SQL Server 2005 onward.

  • +

    Course Syllabus

    - 13m 2s

    —Introduction 1m 57s
    —What This Course Covers 5m 44s
    —What We're NOT Going to Cover 2m 47s
    —Course Order, Focus, and Structure 2m 32s
    Session Settings
    - 57m 2s

    —What This Module Covers 1m 58s
    —Session Settings and Performance-related Features 3m 4s
    —Session Settings That Affect Results (1) 6m 25s
    —Special Considerations: QUOTED_IDENTIFIER 6m 47s
    —Special Considerations: ANSI_NULLS 2m 5s
    —Session Settings that Affect Results (2) 4m 22s
    —Session Settings and Stored Procedures 4m 15s
    —DEMO: SET Options and Performance-related Features (Part 1) 10m 24s
    —DEMO: SET Options and Performance-related Features (Part 2) 17m 39s
    Session Settings (Section 2)
    - 53m 54s
    Special Considerations
    - 56m 10s
    Troubleshooting Techniques
    - 13m 14s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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