3 ms·
> All tables in sqlserver will be memory resident if there is available ram. Right, but Hekaton introduces the option of never requiring your tables to hit the
by BrentOzar 13y ago
> All tables in sqlserver will be memory resident if there is available ram.
Right, but Hekaton introduces the option of never requiring your tables to hit the disk if you don't want them to. Think data warehouse staging tables, web session state, or data marts that are easily recreated from source data.