in memory tables

  • Just started looking at what a migration may be but am I correct that any table that has a rowstamp can not be made an in memory table?

  • ROWVERSION is unsupported. There's a good listing of the supported and unsupported data types here in the Books Online.

    Be very cautious about when and how you're going to apply the in-memory technology. It's absolutely amazing, but it only answers a limited set of functionality. Microsoft has it outlined here. If you're not looking specifically at one of these scenarios, I would be very cautious about the use of the in-memory tables.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply