Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,411 through 40,425 (of 59,072 total)

RE: Delay in record appearing in table - why and how to prevent?

Jack Corbett (12/30/2009)
Are there any triggers?
Spot on... another problem may be an explicitly declared transaction where all this stuff get's stacked up in the log and then get's "released" when...
--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)

December 30, 2009 at 9:08 am

#1097507
RE: Cummulative Totals By Dynamic Month Range

Heh... to wit... the bumble bee doesn't know that it's wings are too small and it's body is too heavy to fly.
--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)

December 30, 2009 at 8:09 am

#1097460
RE: Today's Random Word!

Posers (heh... I hate them and the moroffs that allowed them through the interview).
--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)

December 30, 2009 at 8:00 am

#1097453
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/28/2009)
My requirement is :
1) If any date is misssing in the sequence then i don't want to calculate 'running total' after that row. But i can do the calculation...
--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)

December 30, 2009 at 7:57 am

#1097451
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks for the feedback on the article.
My suggestion would be to start a new post on the forums for this question (it'll expose it to more people and I'm at...
--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)

December 30, 2009 at 7:50 am

#1097447
RE: Cummulative Totals By Dynamic Month Range

tm3 (12/30/2009)
Thanks everyone for your help regarding the dynamic crosstab procedure. I was successful in modifying the section SQL3 to provide cummulative values by month using what Jeff 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)

December 30, 2009 at 7:44 am

#1097444
RE: Cummulative Totals By Dynamic Month Range

Ah... you mean a classic "running total". In order to do that, we'll need to do the "preaggregation" in a temp table, run the running total algorithm over it,...
--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)

December 30, 2009 at 12:19 am

#1097335
RE: The Joy of Numbers

james elmer (1/23/2007)
Good article. Interesting that my create table/insert while loop (to 10,000 rows) executed in 4 seconds and the set based solution executed in 17 seconds.
Heh... guess I've...
--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)

December 30, 2009 at 12:15 am

#1097334
RE: Does the query engine guarantee index order of numbers table in the join..

Not sure which article you're referring to but the answer is "No... not for SELECT's". Even though a SORT won't show up on the execution plan, the only way...
--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)

December 30, 2009 at 12:05 am

#1097329
RE: Service Pack 4

GSquared (12/29/2009)
What makes you think computer software can be different?
What's ironic about that statement is that all software boils down to only two parts... 1's and 0's. I mean,...
--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)

December 29, 2009 at 10:41 pm

#1097315
RE: Comparing Dates

BSavoie (12/29/2009)
Jeffrey, that's exactly what I understood you to say. Seems like a pretty clever idea. Probably not a good solution for EVERY date column in EVERY table. But it...
--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)

December 29, 2009 at 10:38 pm

#1097313
RE: Comparing Dates

Jeffrey Williams-493691 (12/29/2009)
I have to say - I didn't even think I had suggested changing the actual column to a date data type. If it came across that way...
--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)

December 29, 2009 at 10:35 pm

#1097312
RE: Cummulative Totals By Dynamic Month Range

Ok... first, we need a lot of test data to demo this code. Using tm3's code to create a test table and to save later CPR errors (Copy, Paste,...
--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)

December 29, 2009 at 10:16 pm

#1097311
RE: Cummulative Totals By Dynamic Month Range

Heh... as you can tell, there are several problems with the code you have. Lemme see if I can help... I'll be back.
--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)

December 29, 2009 at 9:02 pm

#1097305
RE: Comparing Dates

p.s. If a column has the times on it as well as the dates, that could be important information that will be lost if you strip the times 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)

December 29, 2009 at 4:23 pm

#1097269

Viewing 15 posts - 40,411 through 40,425 (of 59,072 total)