All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
165 views

In memory table vs temporary table - benefits if temdb in already on ram disk

In the docs, we have example of how temporary tables can be replaced with in-memory tables and because a memory-optimized table: is stored only in memory, and has no component on disk involves no IO ...
0
votes
0answers
30 views

SQL Server 2017 - In Memory and Native Compilation

I've been using these features experimentally, but have, to date, encountered 3 big issues. Runtime errors have put the database into a suspect state. This has happened twice. Complicated ...
1
vote
1answer
767 views

Can Entity Framework access In Memory OLTP Tables?

Are there any restrictions with having Entity Framework access In Memory OLTP Tables? Or is this not possible?
2
votes
2answers
93 views

Which user defined data type is memory optimized?

How can i know which one of my uddts is memory optimized? and how can i know it's definition?
0
votes
0answers
90 views

SQL InMemory Natively Compiled SP - unsupported constructs

We're looking at converting several normal T-SQL Stored Procedures into Natively Compiled SPs for performance. The SPs use a ton of #tmp tables - select into, delete from, update from, and several ...
0
votes
3answers
1k views

SQL server in memory table performace [closed]

I am using Microsft SQL Server 2016. I have an SQL table with 140000 rows. It is used only for selecting data. I am trying to increase it's selection performance by making it In-Memory table (it is ...
5
votes
1answer
2k views

In Memory Database Remove File and FileGroup

I have a SQL Server 2016 database and I configured in-memory table. I want to drop this configuration, then I drop that table. When I want to delete that file and filegroup, I got following error. ...
1
vote
1answer
807 views

SQLServer In-Memory database and log file size unexpected increase

I have a strange issue with a SQLServer 2014 (12.0.4439.1) database. I created some months ago a data file and table to play with In-Memory basic features and see if could improve some of our ...
2
votes
1answer
1k views

Using ddl triggers with in-memory tables

I've created server scope ddl trigger to audit user activities on the server. Now if someone tries to create in-memory table the statement fails with the following error: Error SQL72014: .Net ...
0
votes
1answer
43 views

Can not install a database, can I still learn though?

I am given access to a domain where I can put my code in and it will go public, like in this example. In order to store the data right now, I am using PHP and I write the data to a file. When the page ...
5
votes
1answer
831 views

SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback

In SQL Server 2014, In Memory OLTP, What happens, if a transaction is rolled back and newly created version of row is no more required. Is it duty of garbage collector to remove even such type of rows ...
12
votes
3answers
23k views

ALTER DATABASE statement not allowed within multi-statement transaction

I've downloaded the AdventureWorks based In-memory sample from here, and followed all the steps described in the accompanying doc. However, when I try to run the script in SQL Server Management Studio,...