Solved

SQL 2012 and SQL 2014 in memory database

Posted on 2016-11-09
11
36 Views
Last Modified: 2016-11-10
hi,

what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
0
Comment
Question by:marrowyung
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 23

Expert Comment

by:Pawan Kumar
ID: 41881673
In 2014 - SQL Server has introduced In-Memory OLTP Engine.

In-Memory OLTP can significantly improve OLTP database application performance. It improves throughput & improve performance of data scenarios such as temp tables and ETL.

In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for transaction processing.

If you want to read more for quick start - https://msdn.microsoft.com/en-in/library/mt694156.aspx

If you want to read more what new in the SQL Server - https://msdn.microsoft.com/en-us/library/bb500435(v=sql.120).aspx

Hope it helps!!
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881677
I mean the in-memory database engine diff between SQL 2012 and SQL 2014.

e.g. table in replication can't go to memory as it is the limitation .
0
 
LVL 23

Assisted Solution

by:Pawan Kumar
Pawan Kumar earned 125 total points
ID: 41881685
Memory-optimized tables are frequently accessed as part of OLTP. They are stored in memory and the Hard Drive. It improves the speed of transactions run against the tables because the SQL Server system only needs to interact with the data in memory.

These tables are fully durable, ensuring that data from completed transactions will be preserved even if a database crashes. They're accessed using T-SQL commands just like conventional tables.

For replication please go through - https://msdn.microsoft.com/en-us/library/dn600379.aspx

Hope it helps!
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41881770
what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
MSSQL 2012 doesn't have In-Memory OLTP feature.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881791
Victor,

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?
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 125 total points
ID: 41881803
No in-mem prior to SQL Server 2014:

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.
(In-Memory OLTP (In-Memory Optimization))

Do you mean column store indices?
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 41881814
but it has in memory table but seems allow only one non clustered index ?
In-Memory doesn't have indexes.

it don't hav OLAP I knew. but OLTP should have?
As far as I know there's no In-Memory feature for OLAP. Only OLTP.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881848
Victor,

"As far as I know there's no In-Memory feature for OLAP. Only OLTP."

ok, from my remember, SQL 2012 has in memory table for tranaction process but not for Analysis service.

SQL 2014 has OLAP.

"In-Memory doesn't have indexes."

so in memory table don't allow index or SQL 2014 will have ?

ste5an,

I know what you mean, so what news is SQL 2012 then? always on with 4 x replica only ?
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41881869
so in memory table don't allow index or SQL 2014 will have ?
Sorry, I wanted to say "has no clustered indexes".

ok, from my remember, SQL 2012 has in memory table for tranaction process but not for Analysis service.
Really? Can you provide an example?

SQL 2014 has OLAP.
SQL Server has OLAP since MSSQL 2000. What I mean is that In-Memory feature doesn't exists for OLAP as far as I know.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41882331
ok , i will take that advice and search sth more and reply to you all.
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 41883307
tks all
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now