Viewing 15 posts - 3,466 through 3,480 (of 4,080 total)
Listen to Lynn. A recursive CTEs is going to run slowly.
When you DO use recursive CTE, as in any Union ALL, the number and type of columns must...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 4:05 pm
Thanks for letting us know what the resolution was, KT.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 3:46 pm
Please share with us what error you are getting, the table schema(s), and perhaps a sample of data.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 3:26 pm
A lot of our developers just LOVE "NOLOCK".
If you ask them what it means, they usually respond that it means you want to go fast....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 2:12 pm
As long as there is going to be carnage, would you also add to the victims' list the names of those who say "Choose your answer", instead of "Choose all...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 2:09 pm
I will be passing one
Make up your mind, Metro.
First I give you the parser code. Then you said one value.
I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 1:41 pm
I will be passing one
Make up your mind, Metro.
First I give you the parser code. Then you said one value.
I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 1:40 pm
Abby see the puppies? (Or I be see the puppies.)
Well (or hell), them no puppies.
Yes they are. See 'em peein' ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 1:27 pm
Hey Roy, I will translate the Arkansian for you.
Arkansas is infamous for bad grammar and promiscuous former presidents.
Them are ducks.
No them are not.
Yes them are. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 10:27 am
M R Ducks.
No M R not.
S M R. Look at M webbed feet.
L I B !! M R Ducks.
I haven't thought about that since I lived...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 10:20 am
Some of the questions of the day wind up being just trivia, not suggested best practices. But sometimes you stumble across some code that needs fixing and knowing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 10:18 am
Chris #2 is right. I've begun to rewrite some multiline functions as inline table functions and the difference in performance for large batches is astounding. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 9:15 am
I'm just waiting for it to be listed in BOL. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 9:13 am
Easier than I thought it would be !!
Thanks, Simon.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 8:46 am
Yeah that's what we had to do too. The cyborg got all bummed out about it and walked off muttering something about going into politics.
😎
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 8:43 am
Viewing 15 posts - 3,466 through 3,480 (of 4,080 total)