Hi Jim,

There is a slight difference in how log write is done for memory optimized table. For non persisted data, there are no writes to the T-Log. For persisted data, the writes to T-Log are done in batches. If the data is changing for one row very frequently all of these changes are not done to the T-Log. Only one write is done with all the information needed.

Also the changes that are done are written as deltas. This also reduces the writes.

I am lucky to work in a company where they give importance to performance and not worry too much about the $$. On the long run they get their moneys worth. They also encourage us to expand our knowledge.