Viewing 15 posts - 4,111 through 4,125 (of 5,678 total)
Out of sheer curiousity I mucked with the build a bit to see if the substring or the crossapply was the determinator.
The substring is the faster function. I didn'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
February 8, 2011 at 1:49 pm
(450 row(s) affected)
Table '#Tally______________________________________________________________________________________________________________000000000193'. Scan count 450, logical reads 1350, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table '#tmp________________________________________________________________________________________________________________000000000194'. Scan...
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
February 8, 2011 at 1:00 pm
Hm, nice alternative Gus, thanks. Never thought about using Cross Apply like that against Tally.
I used the #Tally to make the code directly consumable. 🙂
I'd originally avoided the substring...
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
February 8, 2011 at 12:44 pm
Can you post the two sqlplans? My guess is something went awry in the predicate selection or something similar.
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
February 8, 2011 at 11:34 am
Brandie Tarvin (2/8/2011)
Tom Brown (2/8/2011)
... but the best of the virtual machines (also a windows 2008 server -64bit) gets a poultry 680. ...
Okay, I have to ask. Did 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
February 8, 2011 at 11:17 am
Ninja's_RGR'us (2/8/2011)
That explains your avatar SO WELL.
:laugh: The fact that it's usually silly or the fact that it doesn't ever seem to be the same one 3 weeks in...
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
February 8, 2011 at 11:06 am
Jack Corbett (2/8/2011)
Ferguson (2/8/2011)
Someone who as a young adult decides to put...
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
February 8, 2011 at 10:27 am
autoexcrement (2/7/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
February 7, 2011 at 9:26 pm
Same parameters?
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
February 7, 2011 at 3:15 pm
Ferguson (2/7/2011)
Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. The position’s primary responsibilities will 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
February 7, 2011 at 3:12 pm
Michael Valentine Jones (2/7/2011)
"Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. "
OLAP may mean that...
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
February 7, 2011 at 3:05 pm
Sounds like another table as a FK assigned against this one.
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
February 7, 2011 at 12:16 pm
You're in SQL 2k8... hit up BOL and review the MERGE command.
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
February 7, 2011 at 12:14 pm
SanDroid (2/7/2011)
Steve Jones - SSC Editor (2/7/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
February 7, 2011 at 12:12 pm
To throw a little fuel on the fire...
Everyone embellishes. Everyone stretches. Why? Because noone rational wants to take the position 'below' them, with less pay, less benefits,...
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
February 7, 2011 at 11:36 am
Viewing 15 posts - 4,111 through 4,125 (of 5,678 total)