Question : Usually companies have separate databases for OLTP and OLAP (Row stores and column stores) where data is loaded […]
Tag: memory-optimized-tables
Use Natively-Compiled Stored Procedures in disk-based tables
Question : Is it completely worthless to use a Natively-Compiled Stored Procedure over disk-based tables? (SQL Server 2016) Should all […]
Conditions for memory optimized tables stored in off-row data table
Question : Memory optimized tables store LOB types in internal tables. I have a table with no explicit LOB types […]
In Memory OLTP causing OOM Issue in SQL Server even though no data in In Memory OLTP Table
Question : We have only 1 memory optimized table in each database and there are total 10 databases as such. […]
Cons of using a star schema in a columnar database
Question : My organisation is implementing a new data warehouse using a columnar data store (Redshift) and the performance is […]
Adding index – There is insufficient system memory in resource pool ‘default’ to run this query
Question : Here’s the query I’m trying to run in order to add an index to my new memory optimized […]
Modifying Schema on secondary replica
Question : I am looking for a solution for a secondary replica change. I have a vendor database that uses […]
Memory Optimized intermittently very slow perfomance
Question : I have a memory optimized table with (in my test) 10 million rows. Running some UPDATE in parallel […]
MEMORY_OPTIMIZED table as replacement for temporary tables
Question : I use temporary tables for complex processing which is done in several “child” procedures. These procedures are working […]
How would you optimize this 2 milion records table or queries?
Question : I have a relatively large InnoDB table that contains domain names, I want to track when they expire, […]