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.
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