Viewing 15 posts - 5,341 through 5,355 (of 5,678 total)
Yep, and that was cheatin', Alvin...
Simon? Ready. Theodore? *munchmunch* 'ere... "AAALLLLVVVVIIIINNNN!!!"
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 6, 2010 at 3:47 pm
Ray K (10/6/2010)
Are we there yet?
And now I have that episode of the Smurfs stuck in my head when they're bringing Brainy to the moon...
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 6, 2010 at 3:46 pm
CirquedeSQLeil (10/6/2010)
Amazing that the thread has experienced ~150 posts so far today. Busy busy thread.
Yeah, Gail was quite busy today...
And Mr. 13, you missed. 😉
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 6, 2010 at 3:45 pm
Hey! hold on there, I want on that wagon!
15!
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 6, 2010 at 3:43 pm
Larry Kruse (10/6/2010)
Many thanks Craig!Your example was pretty damn close...with just a couple of minor tweaks I got it to work!
....
tu1.org_id = 10[/code]
Yawhoops... I'm the man...
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 6, 2010 at 3:36 pm
To hose down the inbound flame war:
Regardless of how the R&D department at Honda works, the point is that the engine is a finished product, then reproduced.
The equivalent of a...
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 6, 2010 at 3:32 pm
Stefan Krzywicki (10/6/2010)
jcrawf02 (10/6/2010)
Alvin Ramard (10/6/2010)
Stefan Krzywicki (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.And with a reference to the start of the thread no less.
We're now in an infinite loop....
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 6, 2010 at 3:26 pm
Sorry, bad code, it should have been:
UPDATE tbl
SET
@carryme = NullableCol = ISNULL( NullableCol, @carryme)
FROM
tbl
ORDER BY
tblID
Oops.
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 6, 2010 at 3:13 pm
You add an identity column to hold ordering in the same positions they're already stuck in. Then you modify a few things like maxdop to make sure you don't...
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 6, 2010 at 3:11 pm
bitbucket-25253 (10/6/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 6, 2010 at 3:04 pm
GilaMonster (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
I suspect it will be tonight now.
Almost certainly. Gonna be all over by tomorrow morning and it's almost bed time for me (approaching...
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 6, 2010 at 3:00 pm
Amit Pandey DeBugSQL (10/6/2010)
Yes I ran the query given by you...
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 6, 2010 at 2:58 pm
Alvin Ramard (10/6/2010)
Tom.Thomson (10/6/2010)
... "Just because I have to be doesn't mean I am" ...I wonder what Descartes would say about that. 😎
Would probably fall under the same header...
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 6, 2010 at 2:55 pm
Shawn Melton (10/6/2010)
Craig Farrell (10/6/2010)Recent posts (Since my last visit). Keeps you on the ball.
Ah..took me a minute to find where that was 😀
And knowing is half the battle!...
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 6, 2010 at 2:35 pm
This query isn't the problem child, but it could be a contributor if default is READ COMMITTED.
EDIT: Whoops. Can you also find out if your READ_COMMITTED_SNAPSHOT is set to...
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 6, 2010 at 2:32 pm
Viewing 15 posts - 5,341 through 5,355 (of 5,678 total)