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
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
