Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,221 through 41,235 (of 59,069 total)

RE: Data allocation in B-tree

Heh... why do you care? It's not like you'll be able to change it or take advantage of it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 7:06 pm

#1076395
RE: Date Conversion problem again

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 7:03 pm

#1076394
RE: update command

Paul White (11/7/2009)
I know not everything in life is about performance...
BWAA-HAA!!! 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 9:15 am

#1076353
RE: Import data from csv file

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 8:22 am

#1076348
RE: Performance Expectations w/ Transactional Replication

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 8:11 am

#1076345
RE: Are the posted questions getting worse?

Bob Hovious 24601 (11/6/2009)
F_PC = M_Bone*A_Meat
Moden's Law?
Heh... you've just given me an idea for a "fun" article. Thanks, Bob.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 8:02 am

#1076340
RE: URGENT: Combining Stored Procedure Output in single result set

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 7:51 am

#1076336
RE: URGENT: Combining Stored Procedure Output in single result set

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 7, 2009 at 7:43 am

#1076332
RE: URGENT: Combining Stored Procedure Output in single result set

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 11:35 pm

#1076253
RE: Inspiring Change

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 10:31 pm

#1076240
RE: Sum(ISNULL(GSTExclusiveAmt,0))

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 10:19 pm

#1076239
RE: How to momentarily stop SQL Server 2005 Transactional Replication?

talltop-969015 (11/6/2009)
Just because a block change has been tested in DEV and QA does not necessarily guarantee that same code is going to work in a production environment every single...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 10:04 pm

#1076236
RE: LEFT JOIN problem

pc131 (11/6/2009)
Hi
Actually 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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 9:50 pm

#1076230
RE: Is there a way to see the cost of a CASE statment

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 9:47 pm

#1076228
RE: Performance Expectations w/ Transactional Replication

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 6, 2009 at 9:37 pm

#1076226

Viewing 15 posts - 41,221 through 41,235 (of 59,069 total)