Jeff Moden

Forum Replies Created

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

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
RE: Calculating time between 2 dates minus time from week(s) end(s)

Peso (5/7/2008)
Michael, what if starttime and endtime is NOT on weekend as op wrote originally?
Jeff, what if starttime AND endtime is ON weekend as op wrote originally?
Dunno.... I wrote 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)

May 8, 2008 at 12:47 am

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

Cool... thanks for the feedback, Eric. Sounds like a great CLR! Any chance of twisting your arm into posting the source code for it?
Also... what did you use...
--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:41 am

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

Well, folks... I guess that's just about it for tonight. I'd also like to say thanks to...
Christopher Ford
David McKinney
humbleDBA
Cory Ellingson
Manie Verster
curbina
tbeadle
JJ B
... 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)

May 8, 2008 at 12:27 am

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

Matt Miller (5/7/2008)
What - only 12 useful tips? in a single article?:hehe:
Stop it now - you're setting the bar too high for the rest of us....
(superlative as usual).....
Ah, my ol'...
--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:23 am

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

Kevin Kennedy (5/7/2008)
Really enjoyed the article.
However... on the parameter split if parameter list happens to be exactually 8000 characters the substring in the select will fail. For example:
DECLARE @Parameter...
--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:18 am

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

Eric Wilson (5/7/2008)
Great article.
I used an "Integers" table for years, but starting with 2005 found that CLR functions to stream out integers is better (faster and takes virtually no space...
--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:05 am

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

Wayne West (5/7/2008)
Excellent article, Jeff! I came across an interesting date table article on Tech Republic that was linked here yesterday after it re-surfaced at BuilderAU.Com.au, I updated 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)

May 7, 2008 at 11:14 pm

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

Steve Rosenbach (5/7/2008)
Jeff, once again, you are my hero!!
Beautifully-written article about such a useful topic.
I've used a "dates" table for quite a while, and actually have a tally table in...
--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 7, 2008 at 11:06 pm

#812218

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