Your technology certification is waiting. Enroll in Cloud Class ®
but it has in memory table but seems allow only one non clustered index ?
it don't hav OLAP I knew. but OLTP should have?
Be seen. Boost your question’s priority for more expert views and faster solutions
what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
New in SQL Server 2014, In-Memory OLTP can significantly improve OLTP database application performance. In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for OLTP.
so in memory table don't allow index or SQL 2014 will have ?
ok, from my remember, SQL 2012 has in memory table for tranaction process but not for Analysis service.
SQL 2014 has OLAP.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.