Skip to main content
67 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
65 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
0 votes
0 answers
104 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
746 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
0 votes
0 answers
677 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
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
1 vote
0 answers
385 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
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
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
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
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
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
1 answer
427 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
0 votes
0 answers
653 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
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
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
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
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
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,116
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
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
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
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
2 answers
754 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
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
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

1
2