The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a regular session during this event.

The session that I’m presenting is:

Table Variables and Temporary Tables: What you NEED to know!

Almost all SQL developers are familiar with table variables and temporary tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between table variables and temporary tables – and the ramifications of those differences – is essential to being able to properly select the appropriate object to use in your development tasks.

In this code-filled session, we’ll explore the similarities and differences of temporary tables and table variables, dispel some widespread myths about each, and answer the most important questions: When do I use one or the other? And what are the various impacts of doing so?

Not just anyone can see this presentation… oh no! You have to attend the summit to see this, so sign up here.

(And if you know something that you think ought to be covered, please respond to this post. I thank you, and all of the attendees will thank you!)