Skip to main content
67 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
66 views

One of our clients has a Azure SQL database running on a P1 Premium Pricing Tier. I created a Memory Optimized table in this database, e.g. CREATE TABLE [dbo].[Foo] ([id] INT ...
DinahMoeHumm's user avatar
  • 976
-1 votes
1 answer
120 views

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 ...
ZedZip's user avatar
  • 6,592
0 votes
0 answers
105 views

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 ...
user2177283's user avatar
  • 333
0 votes
1 answer
153 views

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?
ZedZip's user avatar
  • 6,592
0 votes
1 answer
750 views

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 ...
Sean McKinney's user avatar
  • 57
1 vote
1 answer
259 views

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 ...
Daniel's user avatar
  • 21
0 votes
0 answers
678 views

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 (...
GlennD's user avatar
  • 1
0 votes
1 answer
1k views

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 ...
Boker's user avatar
  • 63
1 vote
2 answers
3k views

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 ...
Guna's user avatar
  • 113
0 votes
1 answer
49 views

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 ...
IT Researcher143's user avatar
  • 111
1 vote
0 answers
387 views

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 ...
Ben Watson's user avatar
  • 159
1 vote
0 answers
67 views

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 ...
SRay's user avatar
  • 11
1 vote
0 answers
252 views

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 ...
ZedZip's user avatar
  • 6,592
12 votes
1 answer
2k views

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 ...
Pinank Lakhani's user avatar
  • 1,129
1 vote
1 answer
379 views

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 ...
Joe H's user avatar
  • 127
6 votes
2 answers
5k views

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 ...
empi's user avatar
  • 16k
5 votes
1 answer
2k views

I want to change the DURABILITY of a memory-optimized table in SQL Server 2016 from SCHEMA_AND_DATA to SCHEMA_ONLY. The Microsoft documentation suggests that the following ALTER TABLE statement ...
Rob Streeting's user avatar
  • 1,725
0 votes
2 answers
1k views

We are developing a web application using ASP.NET MVC Core and using EntityFramework Core for data acess. .net core version is 2.2. Now, We are trying to use MemoryOptimizedTables in SQL server 2016 ...
Huseyin Simsek's user avatar
  • 33
26 votes
5 answers
19k views

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 order to ...
xalessi's user avatar
  • 261
6 votes
2 answers
11k views

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 ...
gio's user avatar
  • 397
0 votes
0 answers
190 views

I have an API that multiple processor requests work from. The job of the the API is to select records from a memory optimized table and mark the status assigned and hand it off to the requester. I ...
alangilbi's user avatar
  • 331
2 votes
0 answers
101 views

Memory Optimized tables: It is my understanding that statistics on memory optimized (MO) tables are created at the time the table is created and is empty, and it never updates. In order to update ...
N_Muller's user avatar
  • 51
2 votes
1 answer
428 views

Is it possible populate a schema_only table (with some initial values) when the database starts, e.g. by invoking a stored procedure? The logic that normally operates on this table would be more ...
user avatar
2 votes
0 answers
1k views

We deployed a new build on Framework v 4.7.2. We also deployed the async Asp.Net session state module and in memory OLTP provider as documented here Our testing environment was fine, and the canary ...
Darkwing's user avatar
  • 7,685
0 votes
0 answers
654 views

I have a table T1 that I created in-memory using the in-memory procedure in SQL Server 2016. Now, I want to create a copy of the same table T1 into another table T2 which should have the same schema i....
testacc's user avatar
  • 155
1 vote
2 answers
69 views

I have a simple self referencing in-memory table CREATE TABLE [Accounts] ( Id UNIQUEIDENTIFIER NOT NULL, [ParentAccount_Id] UNIQUEIDENTIFIER NULL, CONSTRAINT [PK_Accounts] PRIMARY KEY ...
BazMan's user avatar
  • 93
0 votes
0 answers
233 views

I have a script in existing SQL Server 2012 to delete old/expired sessions using partitioning. Data is moved from the source table to the staging table on basis of weekday partition and truncate ...
Ammy's user avatar
  • 1
0 votes
1 answer
338 views

tldr; what is alternative of sp_getapplock in the native compiled stored procedure. I have a memory-optimized table and few indexes on it. it is mission critical app. I am using a memory-optimized ...
Arjun Vachhani's user avatar
  • 1,968
1 vote
1 answer
947 views

Scenario C in This Microsoft Doc describes how temp tables scoped to a connection can be replaced with Memory-Optimized Tables. The scheme uses a Filter Security Policy which calls a function to ...
Christopher J. Grace's user avatar
  • 439
1 vote
0 answers
1k views

I have to work with sets with millions of rows in my SQL Server database. Almost all my commands use the MERGE statement. I merge here and there, this table and that table. I use stored procedures ...
AgentFire's user avatar
  • 9,839
1 vote
1 answer
217 views

After looking into different groups/discussions i didn't found any satisfactory answer of my question, I have around 1.5 TB size Sql server database in production, and there is also a transaction ...
Sohail Hameed's user avatar
  • 988
10 votes
1 answer
4k views

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 Table ...
Pittsburgh DBA's user avatar
  • 6,804
0 votes
2 answers
5k views

I have a database with a memory optimized table. I want to archive this table in another database. I want to write an stored procedure to do that. I am implemented below sample from 1 and 2 ...
afshar's user avatar
  • 713
1 vote
1 answer
2k views

In SQL Server 2016, if we create a database in RAM (i.e using memory optimized tables), the database size should not exceed RAM size, am I right in saying that?
Praveen with 9 Yrs Experience's user avatar
  • 29
1 vote
1 answer
1k views

I have a memory-optimized table in SQL Server 2017 called "User". I'm going to update a row as: using (var context = new MyDbEntities()) { var user = context.Users.Single(p => p.UserId == 1); ...
Mehrdad's user avatar
  • 2,126
0 votes
2 answers
1k views

In SQL Server memory optimized tables, the rowversion data type is not allowed. In my application I still want to be able to detect a concurrency violation where user A opens an item for edit, User ...
Kyle Reed's user avatar
  • 71
0 votes
0 answers
201 views

Error : The function nchar is not supported with natively compiled modules. How I can use Nchar() Function in native Function? my query is : Declare @Input NVARCHAR(MAX) DECLARE @Output NVARCHAR(MAX)...
Narges.valipour's user avatar
  • 1
1 vote
1 answer
962 views

Imagine this scenario in SQL Server 2016: we have to tables A and B A is a memory optimized table B is a normal table We join A and B, and nothing happens and 1000 rows are returned in min time. But ...
Masoud DaneshPour's user avatar
  • 126
4 votes
1 answer
825 views

I'm working with an already built table which I must migrate to a memory optimized one. The following is a clone from the disk based. Both have the same structure with the exception that the disk ...
Leonardo Lanchas's user avatar
  • 1,668
0 votes
2 answers
123 views

In the book "Mastering Azure Analytics: Architecting in the Cloud" by Zoiner Tejada I found a paragraph stating that memory optimized tables are not yet supported as output by Stream Analytics. ...
Markus S.'s user avatar
  • 27
0 votes
2 answers
244 views

i have 2 table something like this. i'm running a hive query and windows function seems pretty limited in hive. Table dept id | name | 1 | a | 2 | b | 3 | c | 4 | d | Table time (build with heavy ...
code-addict's user avatar
  • 137
0 votes
1 answer
1k views

When running a large bulk insert to a durable and a non-durable memory optimized table, I'm getting the same speeds for both. Shouldn't the speed of of a bulk insert to a non-durable memory-optimized ...
Dan Ling's user avatar
  • 2,994
1 vote
1 answer
1k views

I'm using Microsoft SQL Server Enterprise: Core-based Licensing (64-bit) Version 12.0.4100.1 I have a code which creates many non-durable memory-optimized tables, uses them for some things, and ...
JoZ's user avatar
  • 31
1 vote
1 answer
3k views

I have a stored procedure that will convert some dynamic sql into either a temp table or view dependant on a database setting. This is used to "tune" database functionality between different clients ...
Matthew Baker's user avatar
  • 2,729
1 vote
2 answers
755 views

Is it possible for a memory optimized table in SQL server to have part of its data in memory and the rest on disk? I have a requirement to load the last 3 months' data into memory, and the rest of ...
SirG's user avatar
  • 389
4 votes
0 answers
503 views

Using EF 6.1.3, SqlServer 2016. I have recently modified certain tables in my DB to memory optimized tables. Everything functions correctly, however, when I added an after update trigger on a non-...
David Moseby's user avatar
  • 41
0 votes
2 answers
1k views

I am trying to create my first memory optimized table using SQL Server 2014. I first created the necessary file group and file without issue. But when I try to create a simple table using CREATE ...
A. J. Kait's user avatar
  • 1
1 vote
2 answers
429 views

Our current system was architectured like; We have around 5 million records in a DB table. Depending on the need, we get, say a resultset of 1 million records and keep them in cache throughout the ...
Jude's user avatar
  • 2,431
3 votes
2 answers
14k views

I am using a stored procedure which loops through a cursor. Within the cursor I am calling a natively compiled stored procedure. The natively compiled stored procedure does an insert into a memory-...
Reboon's user avatar
  • 578
0 votes
1 answer
182 views

I have a natively compiled stored procedure and I would like to do an async execution of another stored procedure. The background is, that I need to store some staging data as fast as possible (in my ...
Reboon's user avatar
  • 578

1
2