Sharing one of the timeworn topics and we can also find an N number of good articles on this. I also like this topic very much so I would like to write a small note on this. First, Very important point: Temp table is stored in TempDB and Table variable is stored in Memory. The … Continue reading SQL Server: Difference between Temporary Table and Table Variable