Viewing 15 posts - 44,011 through 44,025 (of 59,063 total)
Paul White (4/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 10:31 am
Paul White (4/25/2009)
Hey Flo!These new tally solutions are only fast if all the rows in dbo.JBMTest are identical.
That's exactly what my testing was showing me. Randomness of position of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 10:28 am
Florian Reischl (4/25/2009)
Sorry that the article is still pending, but it is quiet hard to write an article since all test results still changing... I didn't forget, I just...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 9:21 am
Florian Reischl (4/25/2009)
This becomes a bit esoteric but as Bob said "if one tally is fast, two are faster"... If my UNION...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 9:17 am
Derek Dongray (4/24/2009)
Bob Hovious (4/23/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 9:12 am
WayneS (4/24/2009)
GSquared (4/24/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2009 at 9:08 am
Jack Corbett (4/24/2009)
Jeff,If you send me the test code I can run it in 2008. I have it on my laptop.
Very cool, Mr. Corbett. I'll take you...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 5:15 pm
nwinningham (4/24/2009)
AckleyBriannaLynnNULL 46NULL
AckleyBriannaLynnKnox 203B469999999999
Here is my query:
SELECT...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 3:59 pm
WayneS (4/24/2009)
First, fire your developer and store the time in a datetime field.
BWAA-HAA-HAA!!!! Dammit! Ya beat me to it! 😛 Wonder if the developer likes point blank pork...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 3:51 pm
Why not just post it on the Jobs forum on SQLServerCentral.com???? At least that will narrow it down to only a million people who actually think they know what...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 3:48 pm
The good news will come when they finally get all of the windowing functions like SUM() OVER working correctly so we don't have to trick SQL server with things like...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 3:42 pm
Lynn Pettis (4/24/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 1:59 pm
bruce.trimpop (4/24/2009)
Jeff Moden (4/24/2009)
..... I'm talking about code that has been intentionally made slow....
That would seem to imply something malicious on the developers part "intentionally made slow" ?
That aside,...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 11:39 am
Ok... let's peel one potato at a time. Be gentle because I'm a data troll and don't even know how to spell things like ".adp". 😛
First, what parameters would...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 10:51 am
I cannot speak for the others, but I'm not talking about code optimized to the nth degree... I'm talking about code that has been intentionally made slow because the developer...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2009 at 10:45 am
Viewing 15 posts - 44,011 through 44,025 (of 59,063 total)