Viewing 15 posts - 3,511 through 3,525 (of 5,678 total)
I think it has a lot to do with the mindset difference between an app coder and a database developer. I can go on at length but there's 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
April 2, 2011 at 1:30 pm
UMG Developer (4/1/2011)
That is a portion of what I suggested, but it really falls short.
For example if the first table contains 7 rows with a value of 1 and the...
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
April 2, 2011 at 1:22 am
An incredibly quick and dirty way:
CREATE TABLE #T1 (ID INT);
CREATE TABLE #T2 (ID INT);
INSERT INTO #T1 VALUES (1)
INSERT INTO #T1 VALUES (2)
INSERT INTO #T1 VALUES (3)
INSERT INTO #T2 VALUES (1)
INSERT...
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
April 1, 2011 at 6:31 pm
Ninja's_RGR'us (4/1/2011)
That's great, but if you removed the inner joins altogether, this would run probably 5 times faster that it is at the moment...
:blink: So would removing 2/3s of the...
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
April 1, 2011 at 4:10 pm
LutzM (4/1/2011)
Trey Staker (4/1/2011)
Congrats Paul!! IMHO he was an MVP way before Microsoft realized it.seconded.
CONGRATS, Paul!
Well deserved and long due!!
Thirded, very well deserved. Congratulations.
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
April 1, 2011 at 2:15 pm
opc.three (3/31/2011)
Craig Farrell (3/31/2011)
opc.three (3/31/2011)
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
March 31, 2011 at 5:46 pm
James Stover (3/31/2011)
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
March 31, 2011 at 5:42 pm
opc.three (3/31/2011)
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
March 31, 2011 at 5:39 pm
WayneS (3/31/2011)
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
March 31, 2011 at 3:40 pm
ptlbiren (3/31/2011)
Msg 8115, Level 16, State 6, Line 14
Arithmetic overflow error converting varchar to data type numeric.
And also correction in above update statement it is...
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
March 31, 2011 at 3:38 pm
CELKO (3/31/2011)
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
March 31, 2011 at 3:31 pm
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. ...
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
March 31, 2011 at 3:27 pm
Tom Bakerman (3/31/2011)
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
March 31, 2011 at 3:25 pm
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up...
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
March 31, 2011 at 3:19 pm
Roy Ernest (3/31/2011)
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
March 31, 2011 at 3:14 pm
Viewing 15 posts - 3,511 through 3,525 (of 5,678 total)