In this talk I will talk about SQL Server stored procedures and techniques you can use to optimize them. I will cover stored procedures from a developer's point of view including table variables, common table expressions and temporary tables. Which do you use and when do you use it. There will also be a number of quick tips that you can use to improve query performance when you walk out of the session.
You will learn:
- Understand Optimization of stored procedures
- Understand Temporary Tables
- Understand Table Variables