Files for memory-optimized tables

  • Comments posted to this topic are about the item Files for memory-optimized tables

  • 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

  • Easy one, thanks Steve.

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

  • 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.

  • 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
    🙂

  • Nice question, thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • This was removed by the editor as SPAM

  • Nice question, wrong answer... :angry:

    Thanks, Steve!

  • 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

  • Revenant (6/4/2014)


    Nice question, wrong answer... :angry:

    Thanks, Steve!

    + 1 :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • 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

  • easy one.

    thanks Steve.

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

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