66 questions
-1
votes
1
answer
110
views
Using timestamp columns in a memory optimized table
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 ...
- 6,536
0
votes
0
answers
89
views
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 ...
- 333
0
votes
1
answer
130
views
How to delete cascade on Memory-Optimized tables?
I have 2 tables: master->detail, how can I implement 'delete cascade' like referential integrity on delete cascade for disk-based tables?
What way to use?
- 6,536
0
votes
1
answer
564
views
'TRANSACTION ISOLATION LEVEL is set to SNAPSHOT' error when using TransactionScope on Memory Optimised Table
In Memory disk setup on SQL Server with below up
snapshot_isolation_state
snapshot_isolation_state_desc
is_read_committed_snapshot_on
is_memory_optimized_elevate_to_snapshot_on
...
1
vote
1
answer
238
views
Avoid data loss on update while using Memory-Optimized Tables
My company main software have 90% of the business logic on the database (stored procedures). With the last version, Memory-Optimized Tables have been introduced to replace temporary tables used to ...
- 21
0
votes
0
answers
630
views
Memory Optimized table - Adding hash index with included fields
A number of indexes were dropped from a SQL Server 2017 memory-optimized table during a change a couple of months ago. Unfortunately it appears the source code for the original table is not available (...
- 1
0
votes
1
answer
1k
views
Insert into Memory Optimized Table from non optimized
I have two database.
Primary have a DDL triggers so i can't create memory optimized tables there. So i created secondary database and create there table with memory optimized on. Now, in procedure on ...
- 63
2
votes
2
answers
3k
views
The current transaction attempted to update a record that has been updated since this transaction started. The transaction was aborted
I'm trying to update a table which is In-Memory OLTP. There is a scenario where we may have to update a same row in parallel. During concurrent update of a same record I am getting below reported ...
- 113
0
votes
1
answer
48
views
Web config vs In-memory tables/memory optimized tables
In my web.config file for an ASP.NET web application, I have around 150 key-value pairs under <appsettings>. Should I convert this web.config file into an In-Memory table / Memory optimized ...
- 111
1
vote
0
answers
366
views
Cross-database query with memory memory-optimized tables
I am trying to tune a system by using memory optimized tables as a cache for frequently used data. The problem is that my system design has separate database (on the same server) siloed by core ...
- 159
1
vote
0
answers
65
views
Time consumption in Memory Optimize table
I have created one demo like- first created one temp table, then one In Memory table, then some insertion query to insert into the temp table, then used the same insertion query to insert into the In ...
- 11
1
vote
0
answers
245
views
How to return MEMORY OPTIMIZED table from UDF?
How to re-write the UDF returning table variable to the function returns memory-optimized type dbo.TypeOUT ?
DROP FUNCTION [dbo].[test01]
GO
CREATE FUNCTION [dbo].[test01] (@id int)
RETURNS @out ...
- 6,536
11
votes
1
answer
2k
views
Efficiently store large list structure in RocksDB so that the data can be retrieved in pages
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.
But ...
- 1,119
1
vote
1
answer
368
views
Conditional Unique Constraint on Memory Optimized Tables
I am trying to keep integrity in a MEMORY OPTIMIZED table I have. In that table is a foreign key (uniqueidentifier) that points to another table and an Active flag (bit) denoting whether the record is ...
- 127
6
votes
2
answers
4k
views
SQL Server Memory Optimized Table - poor performance compared to temporary table
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) Mar ...
- 15.9k