- February 3, 2015
- Posted by: Warner Chaves
- Category: Database Administration, SQL Server Performance Tuning
In this demo we’re going to show a performance comparison between Classic and In-Memory table variables.
There used to be a myth on the SQL Server community that table variables were “in-memory” and all temp tables should be replaced with table variables. Now we know that myth is FALSE and table variables take allocations from TEMPDB and do IO on TEMPDB as well. Now with SQL Server 2014 In-Memory OLTP we have REAL In-Memory table variables, no myth this time!
This is a very useful pattern that you can apply immediately to large parts of your existing code where table variables are being used. See the video for the details!