ACID Properties

  • srawant

    SSCommitted

    Points: 1829

    Comments posted to this topic are about the item ACID Properties

  • SQLRNNR

    SSC Guru

    Points: 281210

    Nice question and good information for data professionals to understand.

    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

  • M&M

    SSC-Insane

    Points: 21679

    This question is good for interviews :).

    M&M

  • honza.mf

    SSCertifiable

    Points: 5519

    Durable temporary object. Nice idea.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • Stuart Davies

    SSCoach

    Points: 18874

    Good question - hadn't really thought about it until now

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere 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

  • This was removed by the editor as SPAM

  • Mattrick

    Ten Centuries

    Points: 1176

    Nice question. It wasn't overly difficult, but still made you think.

    Thanks,

    Matt

  • Rich Mechaber

    SSChampion

    Points: 10935

    Hmm, never really thought about ACID properties vis-a-vis tempdb: a transaction is a transaction, right? 😉

    Fortunately, the "durable" choice screamed at me "Yo! You think I'll still have your precious data on the next server restart, dog?"

    Nice question: easy, but only after I had to think a bit.

    Rich

  • Mike Is Here

    Hall of Fame

    Points: 3348

    Thanks for the question

  • Chris Harshman

    SSC-Forever

    Points: 41715

    ugh... I always outthink myself, I was sure about durable, but I thought that atomic was also violated since table variables are stored in TempDB but don't participate fully in the transaction even if they are refferenced or modified durring the transaction.

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3944

    tks & good question

    stewartc-708166 (9/7/2011)


    Good question.

    However, there is an error in the referenced article.

    the attributes of ACID are atomicity, consistency, isolation, and durability (during concurrent data operations);

    the article states atomicity, concurrency, isolation, and durability

    Good catch Stewart. I had to go back and read it to believe it! Obviously we are not surprised over the lack of "consistency" in BOL are we?!? :hehe: 😎 😛

  • Ken Wymore

    SSCoach

    Points: 16365

    Nice queston. Thanks

  • This was removed by the editor as SPAM

  • TomThomson

    SSC Guru

    Points: 104765

    A Good question.

    But I thinl it might have been a better question if some extra options (pairs of ACID properties) had been provided, to give people an improved chance of getting it wrong.

    Tom

  • srawant

    SSCommitted

    Points: 1829

    🙂 Yes You are right. I would have done that. Thanks for the feedback.

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

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