The initial understanding about table variable was that it only remains in memory and is not made in temporary database. I remember that I had read in begining that the table variable is only written to TEMPDB database when its size exceeds 2 MB otherwise it remains in memory.
Since when did this logic changed???
commented on Apr 26 2012 12:46AM