Cardinality Estimation - Table Variable Vs Temporary Table in SQL Server
Refer to http://www.sqlvideo.com/AllVideos/Car... for additional details.
This SQL Server Video includes demos. You have the possibility to practice the hands-on examples while watching the video.
SQLTest Tool (http://www.sqltest.org) simulates the hands-on labs for you, no registration necessary.