Top "Memory-optimized-tables" questions

Tables using in memory OLTP ("Hekaton") feature introduced in SQL Server 2014.

ALTER TABLE DROP INDEX failed on a table that isn't memory optimized

I'm trying to drop an index created on a table, but I get this error - The operation 'ALTER TABLE …

Read More
sql azure-sql-database memory-optimized-tables
SQL Server 2014 In-Memory OLTP vs Redis

Is SQL Server 2014's In-Memory OLTP (Hekaton) the same or similar concept with Redis? I use Redis for in-memory storage (…

Read More
sql-server redis memory-optimized-tables
"There is insufficient system memory in resource pool 'default' to run this query" during execution of stored procedure

I am using a stored procedure which loops through a cursor. Within the cursor I am calling a natively compiled …

Read More
sql-server tsql stored-procedures memory memory-optimized-tables