PASS logo

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.