Managing and Writing High-Performance SQL Server Stored Procedures
Stored procedures can improve performance if they're written and executed correctly. Bill Vaughn's session focuses on some best practices to help you optimize performance when working with stored procedures.