Database Administration 1727.Transformational In Memory Performance

Published on February 3rd, 2015 | by Warner Chaves


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!

Tags: , , , , , ,

About the Author

SQL Server Certified Master and MVP. DBA for MS technologies for over 10 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed A SQL Server Web Blog
    Canada, Ontario, Ottawa.

    The Authors