Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

Grant Fritchey (4/16/2009)
Evidently you're not supposed to spit water all over them while laughing. Who knew?
That's some funny stuff when that happens. I did the same thing once...
--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 2:17 pm

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

Bruce W Cassidy (4/16/2009)
WayneS (4/16/2009)
Thomas (4/15/2009)
Using a cross join is not itself counter-intuitive. Using it in this fashion to generate a bunch of numbers probably is to most developers.
I think...
--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 2:12 pm

#979219
RE: One line to drop a (temp) table if it exists

Mike Arney (4/15/2009)
First, thanks for the comment about object_id('tempdb..#t'): I did not realize that would reliably work. I was afraid if 2 sessions both had a #t, object_id() would...
--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:01 pm

#979099
RE: TSQL

arconen (3/26/2009)
In future must show the version of MS SQL Server in order to prevent a misunderstanding.
I answered right for version 2000, but for 2008 I made a mistake.
I absolutely...
--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:52 am

#979094
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

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