Jeff Moden

Forum Replies Created

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

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
RE: spid identified as being blocked by itself

john pan (5/6/2008)
Hi Jeff,
no not this piece of the code, but another sample I ran a qep for has a 9.1 million row table as an input into a select...
--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:07 am

#812253
RE: Performance Problem

jeff.williams3188 (5/7/2008)
Maybe by giving you an example for two SAN's I work with:
HP EVA 5000
Disk Group 1 has 104 72GB/15K drives
Disk Group 2 has 24 300GB/10K drives
When I need 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:00 am

#812251
RE: Parsing a cell into multiple rows

If it's truly a "file" and not just some passed parameter, I'd import it with Bulk Insert or BCP, instead. Dunno about others but I've been able to import...
--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 12:53 am

#812247

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