Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,746 through 50,760 (of 59,098 total)

RE: Tally Table

Holy Moly... that's one heck of a lot of analysis. Did they actually get anything useful out of all that?
--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 6, 2008 at 8:22 am

#811230
RE: The T-SQL Quiz

dfalso (5/6/2008)
{I was encouraged to discuss my position a little better}
I'll attempt to give an example to illustrate (btw, this also illustrates a candidate for an appropriate use of cursors):
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)

May 6, 2008 at 8:18 am

#811226
RE: Tally Table

GSquared (5/6/2008)
Dateadd lists of datetimes. For example, if you need a second-by-second list of all times in a month, or a quarter. (10,000 seconds is a little less...
--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 6, 2008 at 7:31 am

#811186
RE: Cursor not working

Now, you know why I've chosen the Avatar that I have... 🙂
Cursors = RBAR
--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 6, 2008 at 6:53 am

#811157
RE: Running Total variable resolution

The reason why the variable had the value subtracted twice is to make it work properly... you wanted the running total to NOT include the current value and that's 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 6, 2008 at 6:24 am

#811141
RE: Cursor not working

Kent Waldrop (5/5/2008)
Hmm 99.99%. Maybe as far as cursors go you "can't loathe them enough."
Heh... to be clear, I've never written a cursor except to show how slow they...
--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 6, 2008 at 6:15 am

#811132
RE: transfer data from a text file

Sorry... didn't know that...
Still, I posted some questions on that other thread because I need more info to help you. Any answers on those?
--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 6, 2008 at 6:12 am

#811128
RE: Fetch Row by Row with out using cursor

Thank you for the feedback 🙂
--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 6, 2008 at 5:56 am

#811122
RE: Parsing a cell into multiple rows

Like I said, the data needs to be made more consistent... and the code below does that. About all you need to do is change the path to 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 6, 2008 at 5:47 am

#811116
RE: Parsing a cell into multiple rows

wdillon (5/5/2008)
Hi Jeff
Hum, you are right, it's pretty messed up. I'll attach a zip file of the orginal and see if that works.
Thanks
Bill
Thanks... that's a lot better.
Suggestion on using...
--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 6, 2008 at 2:11 am

#811059
RE: Fetch Row by Row with out using cursor

shalini_pdi (5/5/2008)
I have followed the same procedure as u have mentioned. Its working fine. If i execute the code more than once i got the error as There...
--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 6, 2008 at 12:04 am

#811020
RE: Tally Table

GSquared (5/5/2008)
Another excellent article on tally/numbers tables is at:
http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/
by the lovely Robyn Page and the hillarious Phil Factor (I hope I didn't get that backwards 🙂 ).
The only thing 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 5, 2008 at 11:32 pm

#811014
RE: Cursor not working

Levoin (5/5/2008)
Hi Jeff,
Thank you for you answer. Helps a lot.
What's the problem with cursors?
Franck
Two things... first, they consume more resources and locks than necessary... those can be mostly overcome 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)

May 5, 2008 at 9:42 am

#810783
RE: How to import data from a CSV file?

Thanks for the feedback, Sergey!
--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 5, 2008 at 9:28 am

#810774
RE: Running Total variable resolution

Keith DuAime (5/5/2008)
That article, great by the way, is where I got the idea from. I realized I forgot the with index hint and then also added option(maxdop 1) and...
--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 5, 2008 at 8:43 am

#810727

Viewing 15 posts - 50,746 through 50,760 (of 59,098 total)