memory-optimized-tables Questions
1
Description:
RocksDB is a key-value storage so we can simply serialise the list of objects & store the value corresponding to a key. This would be ok if the data in the list is small enough.
...
Martines asked 24/12, 2019 at 6:33
2
Solved
I'm trying to benchmark memory optimized tables in Microsoft SQL Server 2016 with classic temporary tables.
SQL Server version:
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) M...
Fisticuffs asked 14/11, 2019 at 13:59
5
I'm trying to drop an index created on a table, but I get this error -
The operation 'ALTER TABLE DROP INDEX' is supported only with memory optimized tables.
I need to remove this index in ord...
Twink asked 1/5, 2019 at 9:58
2
Trying to understand how transaction isolation levels work on SQL Server memory optimized tables (in-memory oltp).
If I execute the following query:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED...
Insensate asked 3/3, 2019 at 10:59
1
Solved
I have observed that inserting data into a Memory-Optimized Table is much slower than an equivalent parallelized insert to a disk-based table on a 5-SSD stripe set.
--DDL for Memory-Optimized Tabl...
Hoffmann asked 3/2, 2018 at 22:26
2
Solved
Is SQL Server 2014's In-Memory OLTP (Hekaton) the same or similar concept with Redis?
I use Redis for in-memory storage (storage in RAM) and caching, while having a separate SQL Server database (l...
Magdalenmagdalena asked 20/8, 2014 at 10:54
2
Solved
I am using SQL Server 2014 CTP2, with READ_COMMITTED_SNAPSHOT ON (I think it's important for the question).
I have create an In-Memory table type (very similar to the example the technet blog, SQL...
Sardine asked 2/2, 2014 at 7:34
1
© 2022 - 2024 — McMap. All rights reserved.