Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,561 through 43,575 (of 59,063 total)

RE: Are the posted questions getting worse?

Gianluca Sartori (6/5/2009)
Jeff Moden (6/4/2009)
If you don't trust it, then use a cursor or write a CLR. But, many people have tried to make the "quirky" update go wrong...
--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)

June 5, 2009 at 7:33 am

#1005244
RE: Convert Date

You actually store dates like 1/12/2009 in that format in a calendar table? What do you use those for? I'm asking because I'm curious. I've never seen...
--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)

June 4, 2009 at 10:19 pm

#1005009
RE: Convert Date

Bruce W Cassidy (6/4/2009)
Jeff Moden (6/4/2009)
[...]don't store formatted dates in a table... not even a reporting table.
[font="Verdana"]We could have an argument about that, but in general I believe you are...
--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)

June 4, 2009 at 9:00 pm

#1004998
RE: Convert Date

To add to what Luke has already stated, do a simple but powerful test that will prove that storing the formatted date in the table is absolutely the wrong thing...
--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)

June 4, 2009 at 8:22 pm

#1004990
RE: No More SOX

Datamama (6/4/2009)
... and btw - every great DBA I have ever worked with sounds just like you.
Josie
Heh... thanks Josie :blush:. Every good one I've worked with sounds the same...
--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)

June 4, 2009 at 7:49 pm

#1004987
RE: How did default definitions change?

WayneS (6/4/2009)
Paul, I do believe that you found what was going on.
Now, I searched the net for hours, and never found any of these articles. How did you do it?
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)

June 4, 2009 at 7:21 pm

#1004979
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
Jeff Moden (6/4/2009)
Here's the reason why I use Index(0) instead of Index(1). From BOL:
Cheers Jeff - it was your motivation in including the hint I was after...
--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)

June 4, 2009 at 6:11 pm

#1004968
RE: Are the posted questions getting worse?

WayneS (6/4/2009)
Jeff Moden (6/3/2009)
The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor"...
--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)

June 4, 2009 at 6:09 pm

#1004967
RE: Are the posted questions getting worse?

Oh shoot. I almost forgot. In the absence of all indexes on the Temp Table, the ordered CTE or an ordered Derived Table may appear to work just...
--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)

June 4, 2009 at 6:05 pm

#1004966
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
The last time I tried this, the 'intermediate materialization' forced a sort as one would expect, but the QO inserted a later sort to ensure updates were performed...
--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)

June 4, 2009 at 5:50 pm

#1004965
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
Jeff Moden (6/4/2009)
There was some really cool things I was going to show about the Clustered Index but guess folks will just have to wait for the "book"...
--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)

June 4, 2009 at 5:47 pm

#1004964
RE: Are the posted questions getting worse?

WayneS (6/4/2009)
Jeff Moden (6/3/2009)
The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor"...
--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)

June 4, 2009 at 5:45 pm

#1004963
RE: Are the posted questions getting worse?

Adam Machanic (6/4/2009)
With regard to the UPDATE, something you might want to play with instead of relying on the hints is using a CTE and forcing the data to be...
--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)

June 4, 2009 at 5:42 pm

#1004962
RE: Are the posted questions getting worse?

Alvin Ramard (6/4/2009)
Jeff Moden (6/4/2009)
You've never seen the love-of-my-life's checkbook, have you? 😛
Is she the one the Eagles wrote "Take it to the limit" for?
Heh... no. She's actually...
--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)

June 4, 2009 at 1:05 pm

#1004871
RE: Are the posted questions getting worse?

Adam Machanic (6/4/2009)
I assume you don't need to do this with more than 2 billion rows!
You've never seen the love-of-my-life's checkbook, have you? 😛
A bit more information here:
http://sqlblog.com/blogs/adam_machanic/archive/2006/10/03/exploring-the-secrets-of-intermediate-materialization.aspx
Cool... I'll...
--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)

June 4, 2009 at 12:59 pm

#1004866

Viewing 15 posts - 43,561 through 43,575 (of 59,063 total)