Forum Replies Created
Viewing 15 posts - 1,486 through 1,500 (of 4,080 total)
-
RE: Are the posted questions getting worse?
Memphis is about 14 hours by car from Orlando....
ROAD TRIP!!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
I guess I need to have some BBQ for lunch *today*.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Perhaps a BBQ tour is in order.
Lynn, I didn't know it was possible to have a BBQ sandwich that WASN'T pulled pork.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Okay.... now the debate shifts to which BBQ place in Memphis.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query Re-Write to Minimize Logical Reads
I'm not sure it is necessary because the col2 values come from Table A in the first place.
However, upon reflection, it is quite possible that other...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query Re-Write to Minimize Logical Reads
My reasoning was that he first produces a distinct setof values, then gets a simple count of rows from Table A which have values in that set. However...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query Re-Write to Minimize Logical Reads
Without data to test, this is a shot in the dark, but....
SELECT COUNT(DISTINCT docid) -- docid is primary key of Table A
FROM [Table A] a
JOIN [Table B] b...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query Re-Write to Minimize Logical Reads
I'm not sure, Lutz. I'm reading his code more thoroughly right now.
He only wants counts of values that come from Table B.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
I'm getting to come again this year. How early do volunteers have to arrive?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
The reaction would have been the same no matter the nationality/citizenship of the developer; "What the $%@#* are you doing to my data!?!?!?!?!?!"
Answer: $%@#*'ing it up.
Is $%@#*'ing a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
The very thought makes me quiver.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Steve Jones - Editor (7/16/2010)
Kit G (7/16/2010)
The Dixie Flatline (7/16/2010)
It was a dark and stormy night....As I sat down to write...
I was quite a sight...
We could start a rhyme of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
It was a dark and stormy night....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
declare @DoNothing int
begin try
select 1/0 as result
end try
begin catch
set @DoNothing = 1
end catch
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Grant Fritchey (7/15/2010)
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.But...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 1,486 through 1,500 (of 4,080 total)