SQL Server 2014 In-Memory OLTP Use Case - Table Variable Conversion

Описание к видео 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!

And as usual, check out more at SqlTurbo.Com.

Комментарии

Информация по комментариям в разработке