Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,686 through 50,700 (of 59,102 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Wayne West (5/8/2008)
The ISBN is 0-201-55710-X and you can get it on Half.com for $0.75! (http://product.half.ebay.com/_W0QQcpidZ2437565QQprZ1144253)
It was an excellent book for its time, needless to say it's rather dated. ...
--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)

May 8, 2008 at 7:59 pm

#812772
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

GSquared (5/8/2008)
Got as low as 0 CPU one time out of 5, but was 15 or 16 the other 4 times. Not quite as fast as a physical Numbers...
--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)

May 8, 2008 at 7:58 pm

#812771
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

creeds (5/8/2008)
Thanks for the article. I've been using something similar for awhile. I created a function that returns a table of entries. It doesn't run quite 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)

May 8, 2008 at 7:56 pm

#812770
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ian Crandell (5/8/2008)
Jeff,
As always an excellent, excellent article!:smooooth: I have always seen you use the tally table in your posts and you usually explain it, but this article provided...
--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)

May 8, 2008 at 7:54 pm

#812769
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

David Jackson (5/8/2008)
What can I say, excellent article, again! Prompted me to put a link to here[/url] on my site, just to make sure I don't lose these...
Well done...
--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)

May 8, 2008 at 7:40 pm

#812767
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

ALZDBA (5/8/2008)
:humble:
I'm not worthy to even read this article, but I've been a bad boy and did just that. 😀 Mea culpa.
Clear, to the point, no rocket science involved, practical,...
--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)

May 8, 2008 at 7:38 pm

#812766
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Hi Hugo,
Thanks for the feedback on both the "update" problem and the "bin stacking" problem. I'll be sure to post a solution if I come up with one.
--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)

May 8, 2008 at 7:31 pm

#812765
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

p.s. Understood about the random seed... but if you want to generate the exact same test data every time, make a copy of the table.
--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)

May 8, 2008 at 2:26 am

#812285
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Hugo Kornelis (5/8/2008)
Jeff Moden (5/8/2008)
Heh... I really appreciate the feedback, Hugo. Hmmmm... ease of coding... you're saying that writing a WHILE loop is easier to write than a simple...
--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)

May 8, 2008 at 2:17 am

#812283
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Oh no... Hugo! You're one of those folks that actually believes in the myth of code portability! :hehe:
You wrote the following in your blog...
SQL Server will happily update...
--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)

May 8, 2008 at 2:14 am

#812282
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Hugo Kornelis (5/8/2008)
So yes. I am guilty as charged. And will probably continue to be, as I prefer ease of coding over better performance in cases like this, where performance...
--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)

May 8, 2008 at 1:43 am

#812266
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jose (5/8/2008)
Amazing ... you really open my eyes, what a good article.
Best wishes from Peru.
Thanks, Jose. Best wishes from the "U S of 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)

May 8, 2008 at 1:32 am

#812265
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Anirban Paul (5/8/2008)
Jeff
We had a discussion regarding this article couple of days back in another forum. I was waiting for this article. I have no words to praise this one....
--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)

May 8, 2008 at 1:31 am

#812263
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Eric Wilson (5/8/2008)
A "Tally" table (sorry Jeff) is a bad name though. It really should be just an "Integer" domain table.
Not a problem... a rose is a rose and I...
--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)

May 8, 2008 at 1:29 am

#812261
RE: dbcc showcontig - why does it show an index that doesn't exist?

Sorry for the delay, Neil...
No, those don't look like the stats or system generated indexes I was expecting. I don't know on this one... my appologies.
--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)

May 8, 2008 at 1:11 am

#812254

Viewing 15 posts - 50,686 through 50,700 (of 59,102 total)