PASS logo

November 14-17

In person. In Seattle

2021 Summit video library

CTEs vs Table Variables vs Temporary Tables

Dale Sullenberger

The temporary object you choose could have big impacts on performance. Each has its pros and cons, but understanding some of the basics of how the database engine uses them, and the differences of each can help you choose the right tool for the particular job. 

Get updates

Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.