PASS logo

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 the Latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.