SQL Server

TH25 Optimizing Stored Procedures


3:00 pm - 4:15 pm

Mark Rosenberg

Technical Instructor

New Horizons

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