4 ms·
It's a good overview you've shared of the storage technologies in SQL Server. I agree on memory-optimized being ideal for a real time service. The overhead of
by greggyb 7y ago
It's a good overview you've shared of the storage technologies in SQL Server.
I agree on memory-optimized being ideal for a real time service. The overhead of column indexing has ruled it out whenever I've benchmarked it for real time use cases. Last time was on SQL 2016, so latest optimizations may have brought it to par.