In-Memory OLTP - SQL Server 2014

Question

Post reply

In-Memory OLTP - SQL Server 2014

Ford Fairlane

SSCertifiable

Points: 7664
More actions
March 9, 2014 at 12:58 am

#305172

Comments posted to this topic are about the item In-Memory OLTP - SQL Server 2014
Hope this helps...
Ford Fairlane
Rock and Roll Detective
March 10, 2014 at 4:36 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

First explanation in QotD since quite long time without a reference!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Nice question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Woohoo, it depends.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Good question, need to do some research.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

SQLRNNR (3/9/2014)
Woohoo, it depends.

Every question should have this as an extra option 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Stuart Davies SSCoach Points: 19505 More actions · Answer 6

SQLRNNR (3/9/2014)
Woohoo, it depends.

+1

Thanks for the question

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

If 'could be' is an option, it's often right.

Should have gone for that.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

I haven't gotten to play with 2014 yet, but I remembered this feature from a presentation I saw. Very interesting, but limited in use and not the ultimate panacea I think people were hoping for. Memory-optimized tables are another tool in the toolbox and not the cure-all for all performance woes.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Anoo S Pillai Mr or Mrs. 500 Points: 547 More actions · Answer 9

Anoo S Pillai

Mr or Mrs. 500

Points: 547

March 10, 2014 at 5:46 am

#1695489

Questions on new features !! Thanks..

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 10

PChiragS

SSCarpal Tunnel

Points: 4965

March 10, 2014 at 7:27 am

#1695513

thanks for the nice and interesting question..

Dana Medley SSCertifiable Points: 6764 More actions · Answer 11

Thanks for the great question.

Everything is awesome!

h.tobisch SSCommitted Points: 1671 More actions · Answer 12

Sorry, you are wrong.

As Memory Optimized Tables are memory resident, the data is Not-Durable upon System Restart/Crash --> this means from A you can deduce B.

As this cannot be deduced (you write there are 2 options) the statement is FALSE.

J DBA SSCertifiable Points: 5008 More actions · Answer 13

h.tobisch (3/10/2014)
Sorry, you are wrong.
As Memory Optimized Tables are memory resident, the data is Not-Durable upon System Restart/Crash --> this means from A you can deduce B.
As this cannot be deduced (you write there are 2 options) the statement is FALSE.

According to this link, data can be durable if you set up your Memory Optimized Objects with the Schema_And_Data option.

http://msdn.microsoft.com/en-us/library/dn553122(v=sql.120).aspx

J DBA