Day 16. Optimizing Stored Procedures

In yesterday's lesson, you learned the basics of creating stored procedures. As always, a little knowledge can be very dangerous. Unless you understand the effect that a stored procedure can have on the performance of the SQL Server, you might create very poorly optimized SQL scripts. Today, you will learn the following topics as they relate to stored procedures:

• Optimizing stored procedures

• Using temporary tables

• Controlling compilation

• Transaction processing