Files for memory-optimized tables

Question

Files for memory-optimized tables

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
June 4, 2014 at 12:01 am

#74493

Comments posted to this topic are about the item Files for memory-optimized tables
June 4, 2014 at 3:35 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

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

Easy one (as I watched a session on Hekaton last week), thanks!

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

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

Easy one, thanks Steve.

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Thank you for the post, Steve, nice one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

rhythmk SSCertifiable Points: 7271 More actions · Answer 4

Thanks for question Steve.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 5

Nice question, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

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

Nice question. Thanks.

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

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Nice question, wrong answer... :angry:

Thanks, Steve!

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the data is not up to date, there is no way you can recover the date - it's lost. Equally if I destroy the data file when the log doesn't go back to the beginning of history, it's unlikely that I can recover the data (unless of course I have backup). So at least those two table are needed. The data and delta files are updated by a backrground process so that at any time (other than at a checkpoint) they do not represemt the state of teh table.

Or to put it in simple terms, the question and annswer is wrong. Amd this is confirmed in the page referenced in the application!

Tom

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Revenant (6/4/2014)
Nice question, wrong answer... :angry:
Thanks, Steve!

+ 1 :w00t:

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

TomThomson (6/5/2014)
Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the data is not up to date, there is no way you can recover the date - it's lost. Equally if I destroy the data file when the log doesn't go back to the beginning of history, it's unlikely that I can recover the data (unless of course I have backup). So at least those two table are needed. The data and delta files are updated by a backrground process so that at any time (other than at a checkpoint) they do not represemt the state of teh table.
Or to put it in simple terms, the question and annswer is wrong. Amd this is confirmed in the page referenced in the application!

+ 1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 11

PChiragS

SSCarpal Tunnel

Points: 4965

June 9, 2014 at 10:07 am

#1720154

easy one.

thanks Steve.