Viewing 15 posts - 2,821 through 2,835 (of 4,080 total)
Just whenever you get a chance. Thanks, prodigy.
The great thing about this is we all get a deeper understanding of what's going on under the hood. That's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2009 at 8:11 am
I'm also curious to know if it does 9 scans on the nonclustered index. Can you post those stats up too?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2009 at 8:05 am
Is EntityCollection a partitioned table by any chance?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2009 at 7:13 am
Prodigy, what else is going on in your proc? I see a simple Select Count statement but you post that it's taking 9 scans of the table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 5:48 pm
(message found inside a magnetic bottle drifting between the stars)
Barry: Consider yourself fortunate. - bh
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 4:06 pm
(appears briefly due to a temporal anomaly)
Snoop with a banjo??
The tune is original, like the lyrics. I'm making this up as I go along. 😉
(suddenly sucked back...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 3:55 pm
(warps in)
You know I love the ladies: silver, gold, blue or green,
Hot pink, fluorescent purple, and some shades in between.
I charm them and disarm them, if you know what...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 3:39 pm
Nawar, although your function may get the desired result, using a while loop is going to run much slower than a set based solution. If you will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 3:13 pm
I'm inspired!! Imagine a banjo....
Ohhhhhhhhhhhh
I call up Engineering... holler "Gimme warp three"
I got a half a billion Klingons all as pissed as they can be
And the pointy-eared alien...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 10:30 am
Exhibit 1: The Heisenberg compensators. That's one piece of startrek technology I wish would come true.
Gail, to quote Heisenberg: "It might." 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 12, 2009 at 10:26 am
With MY name on it ??? :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2009 at 4:42 pm
No rules?! Then why are you fingering your red card in a threatening manner, Lynn? 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2009 at 4:34 pm
Maxims of a Klingon Code Warrior:
10.Specifications are for the weak and timid!
9.You question the worthiness of my code? I should kill you where you stand!
8.Indentation?! - I will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2009 at 3:25 pm
Q: What's a Red Shirt's favorite color?
A: We don't know... they keep dying off before we can ask them.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2009 at 12:05 pm
Martin, you may find this a little easier to understand. It is what some people call a crosstab approach, although it produces the same result in your case...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2009 at 11:50 am
Viewing 15 posts - 2,821 through 2,835 (of 4,080 total)