Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,161 through 44,175 (of 59,097 total)

RE: Are the posted questions getting worse?

Grant Fritchey (4/16/2009)
Jeff Moden (4/16/2009)
Thread softly and carry a big pork chop.
You owe my company a new monitor.
Ha!
BWAA-HAA!!! "Let them eat thread!"
--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)

April 16, 2009 at 11:40 am

#979090
RE: Are the posted questions getting worse?

Thread softly and carry a big pork chop.
Don't thread on me.
Give me thread or give set based.
To thread or not to thread... that is the question.
"42" has been replaced by...
--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)

April 16, 2009 at 11:20 am

#979074
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

UMG Developer (4/16/2009)
Jeff Moden (4/16/2009)
Here's the code...
[font="Courier New"]DECLARE @PrevActualCost MONEY,
        @RunningTotal   MONEY,
        @PrevID         INT
SELECT @PrevActualCost = 0,
        @RunningTotal   = 0
UPDATE t
    SET @RunningTotal = RunningTotal = @RunningTotal + ActualCost,
        @PrevID       = ID
   FROM #tmp 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)

April 16, 2009 at 10:58 am

#979063
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

WayneS (4/16/2009)
Maybe someday, I can teach Jeff something.
You just did. Thanks, Wayne.
--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)

April 16, 2009 at 10:15 am

#979011
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

mtrafzer (4/16/2009)
I have been a programmer for over 20 years. We all know that cursors are bad. We were all told that when we learned how to do...
--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)

April 16, 2009 at 10:12 am

#979004
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Oh yeah... almost forgot... the "black art" running total method requires that you have the proper clustered index to work. It will not work correctly if you reference a...
--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)

April 16, 2009 at 1:32 am

#978645
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Mr. Young... very nice job. Immensely entertaining article and follow up posts to boot. My hat is off to you, Sir... I know just what you're going through...
--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)

April 16, 2009 at 1:16 am

#978640
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Michelle Gutzait (4/15/2009)
... And I was wondering... 🙂
What are your thoughts about Adam Machanic's article:
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx ?
I tried to compare Adam's code to other options and came up with this...
--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)

April 16, 2009 at 12:52 am

#978635
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/15/2009)
Jeff,
Look at features you need to know to write the while loop vs. the cross Join. In the case of the while loop, you need to know about the...
--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)

April 16, 2009 at 12:00 am

#978613
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

As always with such a hot topic, the great battle between the "intuitiveness" of cursors comes forward. The classic example on this thread seems to have been based on...
--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)

April 15, 2009 at 10:51 pm

#978600
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

James Tran (4/14/2009)
Good article RBarry Young. I got rid of my cursor by
- Store the result data in table var with rownumber
- create a row index var...
--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)

April 15, 2009 at 9:44 pm

#978582
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

SanjayAttray (4/14/2009)
Interesting article. Would be waiting for second installment. Cursors are bad ( period ) but in some situations we had to use them. It becomes necessary....
--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)

April 15, 2009 at 9:36 pm

#978580
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Manie Verster (4/14/2009)
Steve had an article a couple of days ago about breaking down code in a stored proc/query to make it more readable and editable. Sometimes cursors help you...
--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)

April 15, 2009 at 9:24 pm

#978576
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

ZA_Crafty (4/15/2009)
gautamsheth2000 (4/13/2009)
Should use this code 🙂
Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
You can do even one better.
using the PK in count is faster than *
ie,
Select count(id)...
--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)

April 15, 2009 at 9:11 pm

#978570
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/15/2009)
However, I have, in my travels, run into situations where even though a set-based solution existed, it performed worse than a cursor in that particular version of the DBMS...
--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)

April 15, 2009 at 8:25 pm

#978563

Viewing 15 posts - 44,161 through 44,175 (of 59,097 total)