<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Halloween Protection
55 posts, Page 1 of 6
1
2
3
4
5
»
»»
Halloween Protection
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, October 30, 2012 8:09 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 1:14 AM
Points: 31,433,
Visits: 13,746
Comments posted to this topic are about the item
Halloween Protection
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1379132
bitbucket-25253
bitbucket-25253
Posted Tuesday, October 30, 2012 8:11 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 9:12 PM
Points: 5,103,
Visits: 20,208
Hmm caught me on that one with Halloween coming up in the USA tomorrow thought this was one of those joke questions ... OH well so be it
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1379133
L' Eomot Inversé
L' Eomot Inversé
Posted Tuesday, October 30, 2012 9:42 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 7,106,
Visits: 7,173
Nice question.
I wonder how many people here ever used System R. I didn't, for one.
Now, was it Halloween 1976 or Halloween 1977 when it acquired its name (or, more exactly, when the problem got the name "the Halloween Problem")?
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1379141
kalyani.k478
kalyani.k478
Posted Tuesday, October 30, 2012 9:52 PM
SSChasing Mays
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616,
Visits: 97
ha...nice question....
thought this a fun ques category,,,n guessed the answer...got it right though:)
Finally learnt the concept through the link..thanks:)
Post #1379142
demonfox
demonfox
Posted Tuesday, October 30, 2012 10:03 PM
Ten Centuries
Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074,
Visits: 1,076
cool ; i didn't know ....
nice question
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1379143
Lokesh Vij
Lokesh Vij
Posted Tuesday, October 30, 2012 10:14 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176,
Visits: 1,253
Unaware of "Halloween Protection", I thought this to be some kind of a funny question [cooked-up] initially
Got to learn something new, which I was unaware of!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1379144
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, October 31, 2012 12:19 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
Great question! Forced me to do some research.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1379157
Andrew Diniz
Andrew Diniz
Posted Wednesday, October 31, 2012 3:14 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:04 AM
Points: 189,
Visits: 243
Nice one! I came across this last year whilst studying for an exam.
Shouldn't the options, CREATE, DELETE, INSERT, UPDATE and SELECT be checkboxes though as opposed to radio buttons? After all, it is possible to observe 'Halloween Protection' in DELETE and INSERT plans too
Post #1379207
GilaMonster
GilaMonster
Posted Wednesday, October 31, 2012 3:38 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:28 AM
Points: 37,735,
Visits: 30,005
Andrew Diniz (10/31/2012)
After all, it is possible to observe 'Halloween Protection' in DELETE and INSERT plans too
No, the Halloween problem is exclusively for updates. You can't insert or delete a row multiple times, you can an update and that's the problem. You may see spools in insert or delete plans, but they are not there for halloween protection.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1379213
Nakul Vachhrajani
Nakul Vachhrajani
Posted Wednesday, October 31, 2012 4:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:02 AM
Points: 1,277,
Visits: 1,609
Very nice question! With a little thought, I was certain about the answer. While this was the first time I heard about "halloween protection", the chain of thought I used was Halloween = ghosts & goblins. Ghosts = phantom. We all know about "phantom updates" and hence the answer had to be what it is.
This one has to be the best of the fun series - simply because it teaches something new. Further reading into "Halloween protection" gave me some great insight into what it really is and how can we prevent it.
Happy Halloween, everyone! (And for those who got caught in the storm, I pray that you did not face any major losses).
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1379223
« Prev Topic
|
Next Topic »
55 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
