Viewing 15 posts - 5,281 through 5,295 (of 5,678 total)
Rats. I had hoped the Sargable nature of your code vs. mine would have improved performance. Guess it would depend on the base data set though and how...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 4:14 pm
Paul White NZ (10/14/2010)
For 2005 onward, consider adding the 'safety code' I mentioned - you can find it here: http://www.sqlservercentral.com/Forums/FindPost980118.aspx
Well, far be it from me to turn down a damned...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 3:33 pm
GilaMonster (10/14/2010)
Craig Farrell (10/14/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 3:04 pm
David Portas (10/14/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 2:56 pm
A couple of code shops I've been in were nothing but hamburger code. We fixed it only when we heard screams of murder, we pushed out code as fast...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 2:43 pm
Paul White NZ (10/14/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 2:32 pm
Sorry Paul, that was a bit abrupt and you deserve better than that, your explainations are always concise and instructive.
I would agree in general that quirky update should not be...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 11:06 am
Paul White NZ (10/13/2010)
Craig Farrell (10/8/2010)
Craig,You can't use joins in a Quirky Update.
Paul
Can't, or shouldn't? I did get the correct results here when I tested the code, with no...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 10:40 am
R.P., did you set up a 10k/20k row test for that algorithm? I'm curious to see how it compared to the simple inline code above.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 10:37 am
I like visio, but I don't typically use the automation tools. I've got a toolbar that I've built a few shapes into to help me with, but primarily I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 10:26 am
GilaMonster (10/14/2010)
GilaMonster (10/13/2010)
Not from here, but how's this one:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151492
Background is that he mailed me twice within 10 min, subject line 'Answer this' and just a link to that thread.
Update:
He apparently...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 2:58 am
WayneS (10/13/2010)
Craig Farrell (10/13/2010)
Heh, glad I ducked this one Wayne. http://www.sqlservercentral.com/Forums/Topic1003666-338-1.aspxI think you were kinder then I would be at the end there.
:hehe:
Which begs the question... how would you have...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 14, 2010 at 2:55 am
Hmm... Would a cascading delete then be a very large boulder rolled along the library shelves? 😀
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 13, 2010 at 6:05 pm
Heh, glad I ducked this one Wayne. http://www.sqlservercentral.com/Forums/Topic1003666-338-1.aspx
I think you were kinder then I would be at the end there.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 13, 2010 at 4:43 pm
David Portas (10/13/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 13, 2010 at 4:37 pm
Viewing 15 posts - 5,281 through 5,295 (of 5,678 total)