Published on February 3rd, 2015 | by Warner Chaves0
Video: Sql Server 2014 In-Memory OLTP Use Case: “Table Variable Conversion”
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!