Viewing 15 posts - 2,386 through 2,400 (of 5,678 total)
The execution plan for this is some serious ugly. I'm getting ~ 1 minute runtimes on my PC, but I want to make sure the logic is what you're...
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 31, 2011 at 2:23 pm
Brian Kier (10/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
October 31, 2011 at 1:18 pm
isuckatsql (10/31/2011)
Why is SSIS such a dog ?
Erm, because we took the watermelon for a walk and found Batman playing Hopscotch?
Honestly, without knowing more details about how you applied 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
October 31, 2011 at 1:13 pm
PhilM99 (10/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
October 31, 2011 at 1:07 pm
Brian Kier (10/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
October 31, 2011 at 1:05 pm
Can you give a little more detail as to the process you'd like the SQL to perform?
In my head, I'm thinking you'd just grab MAX(flowrate) group by (Hour Dividers), but...
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 31, 2011 at 12:44 pm
You're looking for PIVOT, or Crosstab query. 🙂 Two methods, same basic result.
I hate it when I don't know the keyword either, drives me nuts. Let us know...
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 28, 2011 at 2:43 pm
aureolin (10/28/2011)
Evil Kraig F (10/27/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
October 28, 2011 at 2:05 pm
bdotjones (10/27/2011)
Evil Kraig F (10/27/2011)
Not with GETDATE(), no.
You could generate a CLR function, or even just a database function, to replace this. However, you can't directly overload the GETDATE()...
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 28, 2011 at 12:56 pm
Lexa (10/28/2011)
GilaMonster (10/28/2011)
I'd like to see the exec plan with the scan please.
Now that I updated stats, don't seem to have any scans at all... But will post if 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 28, 2011 at 12:46 pm
Agreed.
Lexa, I realize you purposely obfuscated that index, but we're going to need more to really get into this if you want to. Part of it is because we're...
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 28, 2011 at 12:45 pm
L' Eomot Inversé (10/27/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
October 28, 2011 at 12:34 pm
bdotjones (10/27/2011)
I have to allow users enter dates that are future or past dates based off the offset values that are stored in the database. So if today is 10/27/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
October 27, 2011 at 6:44 pm
Estimated data volume and cost of traversing just the leaf level vs. running the tree repeatedly.
One example cause: http://sqlskills.com/BLOGS/KIMBERLY/category/The-Tipping-Point.aspx
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 27, 2011 at 6:40 pm
I'm going to have to be a dissenting voice, I agree with Paul as to the nature of 'executes first'. It's what starts the chain, and begins the process.
Thanks...
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 27, 2011 at 6:32 pm
Viewing 15 posts - 2,386 through 2,400 (of 5,678 total)