ACID Properties

Question

ACID Properties

srawant

SSCommitted

Points: 1829
More actions
September 6, 2011 at 9:08 pm

#257004

Comments posted to this topic are about the item ACID Properties
September 7, 2011 at 5:44 am

This was removed by the editor as SPAM
September 7, 2011 at 2:32 pm

This was removed by the editor as SPAM

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

September 6, 2011 at 10:08 pm

#1377771

This question is good for interviews :).

M&M

honza.mf SSCertifiable Points: 5519 More actions · Answer 3

Durable temporary object. Nice idea.

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

Stuart Davies SSCoach Points: 19505 More actions · Answer 4

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

Mattrick Ten Centuries Points: 1176 More actions · Answer 5

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

Thanks,

Matt

Rich Mechaber SSChampion Points: 11130 More actions · Answer 6

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 More actions · Answer 7

Mike Is Here

Hall of Fame

Points: 3348

September 7, 2011 at 8:33 am

#1378013

Thanks for the question

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 8

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 SSCarpal Tunnel Points: 4054 More actions · Answer 9

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 SSCoach Points: 17191 More actions · Answer 10

Ken

SSCoach

Points: 17191

September 7, 2011 at 2:02 pm

#1378262

Nice queston. Thanks

TomThomson SSC Guru Points: 104773 More actions · Answer 11

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 More actions · Answer 12

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