Viewing 15 posts - 41,221 through 41,235 (of 59,069 total)
Heh... why do you care? It's not like you'll be able to change it or take advantage of it.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 7:06 pm
This will solve the problem of finding everyone 71 years of age or older and still stand a chance of using an index... of course, it's untested because you didn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 7:03 pm
Paul White (11/7/2009)
I know not everything in life is about performance...
BWAA-HAA!!! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 9:15 am
Heh... I LOVE batch files. 😛
Point well taken, though. I've been put off of SSIS (and, previously, DTS) because of what I've seen people do with it... they can't...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 8:22 am
Thanks for the info and the corrections. Although replication certainly has some good uses, I'll always think of it as a bit of a pain because of problems as...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 8:11 am
Bob Hovious 24601 (11/6/2009)
FPC = MBone*AMeat
Moden's Law?
Heh... you've just given me an idea for a "fun" article. Thanks, Bob.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 8:02 am
deepakkn (11/6/2009)
Hi,I want to combine the output of multiple stored procedures in a single result set.
The output columns of all the stored procedures will be same.
Ex:
EXEC sp_getClientsList
UNION ALL
EXEC sp_getClientsList
I agree...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 7:51 am
Thanks for the info, Paul.
Switching gears... I'll always be humble when it comes to something I don't know, though. 🙂 It's just my nature.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2009 at 7:43 am
deepakkn (11/6/2009)
Thanks for the Reply Paul.We had a thought about SSIS packages.But that would hamper my performance.
Paul... like the other post, not being snarky here... I just don't know for...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 11:35 pm
Heh... what's really funny about that is I've seen the same thing. And, they all knew that boots had straps but didn't know what a boot looked like. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 10:31 pm
Paul White (11/6/2009)
[font="Courier New"]Warning: Null value is eliminated by an aggregate or other SET operation.[/font](suppressed by SET ANSI_WARNINGS OFF)
Correct on both counts... except for distributed transactions (IIRC).
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 10:19 pm
talltop-969015 (11/6/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 10:04 pm
pc131 (11/6/2009)
HiActually it was MySQL 5 issue, but I was looking for high traffic forums, so i put it here.
Thanks
Heh... that's like standing in traffic to see if you'll get...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 9:50 pm
Dave Ballantyne (11/6/2009)
Absolutely. If you are doing performance comparisons, use millions of rows. One or two iterations really dont prove anything.Should be simple enough to do.
It...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 9:47 pm
Ian Scarlett (11/6/2009)
Jeff Moden (11/5/2009)
Most of it is all very, very fast because it uses BCP behind the scenes.
Are you sure, Jeff?
I know the initial snapshot uses BCP, but (unless...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2009 at 9:37 pm
Viewing 15 posts - 41,221 through 41,235 (of 59,069 total)