SQL Server: Optimizing Stored Procedure Performance

You will need to use stored procedures if you want to make your code more efficient. They are designed to optimize and compile code that is stored in a cache for faster executions. It might not work that way every time. Performance of a stored procedure depends on how it is selected and cached. Performance could suffer if the plan isn't optimized for subsequent executions. You might end up with what is known as the optimal plan for a procedure that varies depending on the parameters. This course will show you how SQL Server works to create the best plan for your stored procedures performance under different circumstances. Anyone who writes stored procedures that need to perform consistently well can benefit from this course. SQL Server 2008 to SQL Server 2014 are compatible with the demo database. All course demos can be viewed on SQL Server 2014, with references to the behaviors on each version. The course covers optimization strategies for SQL Server 2005 and later, some back to SQL Server 2000.