Relative Content

Tag Archive for sql-servermemory-optimized-tables

SQL Server Memory-Optimized tables: timestamp columns

I am researching how to convert some physical tables to memory-optimized tables.
But these tables have timestamp column.
This data type is not supported in MO. How to replace it? Now these columns used in app to compare and check if another app changed the row.

Why Table Spool on MemoryOptimized table and how to suppress it?

I am in the middle of the road to achieving an optimized query for faster execution, or at least I hope so. I stumbled upon a pattern (it looks strange to me) in the execution plan, which seems to be responsible for around half of the execution time currently. I did a research on the topic and this is how I managed to optimize it so far.