Understanding Why and How Stored Procedures Work

Duration:  14 Minutes 05 Seconds (8.7 MB)

In this SQL Tutorial we explore why Stored Procedures are important as you develop your database applications and maintain the data. We will also look at the notion of an execution plan and how SQL Server creates an execution plan for your stored procedure then how it caches that execution plan to improve performance.

• Understand importance of stored procedures


• Introduction to execution plans