ACID Properties

  • Comments posted to this topic are about the item ACID Properties

  • 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
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • This question is good for interviews :).


  • Durable temporary object. Nice idea.

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

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

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

  • This was removed by the editor as SPAM

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



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


  • Thanks for the question

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

  • 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: 😎 😛

  • Nice queston. Thanks

  • This was removed by the editor as SPAM

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


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

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

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