• And how long does it take to do that to a normal disk-based table?

    I tested it out, with the load I could generate on a laptop I could not get a measurable performance difference between disk-based table and memory table. Which is to be expected, since it's aimed at very high volume inserts (thousands of small inserts a second) and small queries, not at queries returning millions of rows, which is more the job of Columnstore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass