Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,606 through 43,620 (of 59,097 total)

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
RE: Are the posted questions getting worse?

RBarryYoung (6/4/2009)
Hey, Jeff is back! 😀 Great stuff Jeff.
Thanks for the pick-me-up Barry! I was Jonesing for some good SSC. Have been pretty well distracted lately.
--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:29 pm

#1004852
RE: Are the posted questions getting worse?

Gianluca Sartori (6/4/2009)
Jeff, has your avatar something in common with this?
http://www.youtube.com/watch?v=vF4iWIE77Ts
It's incredible I didn't notice it before!!
That's the 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)

June 4, 2009 at 12:27 pm

#1004850
RE: Convert Date

Krasavita (6/4/2009)
I have a field at datetime 1/1/2009 12:00:00 AM, how can I convert it to 1/1/2009.Thank you
Once you have it converted, where will you use the converted date? ...
--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:24 pm

#1004847
RE: Are the posted questions getting worse?

Adam Machanic (6/4/2009)
Jeff Moden (6/4/2009)
To wit, I agree that the ordered CTE works in the absence of a clustered index but you might want to try the ordered CTE 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)

June 4, 2009 at 12:13 pm

#1004839
RE: Are the posted questions getting worse?

Lynn Pettis (6/4/2009)
Oh, please tell me exactly what I need to do. I have NO IDEA how to look things up in BOL.
Heh... if you really want to have...
--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:06 pm

#1004834
RE: Are the posted questions getting worse?

Adam Machanic (6/4/2009)
OK, that's a pretty good case. I'll have to revisit my own example and try to figure out why I'm not seeing such an extreme difference. 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)

June 4, 2009 at 11:58 am

#1004825
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
The ultimate demo is where the original table already happens to have a suitable clustered index (it does happen!) and an existing column for the running total needs...
--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 11:42 am

#1004816
RE: Are the posted questions getting worse?

Grant Fritchey (6/4/2009)
Jeff, after you install the hand rails, you'll also need one of these:
BWAA-HAAA!!! Thanks for the help. Looks like I'm gonna need the hand rails after all,...
--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 am

#1004564
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
Way to tell that it's index order, not allocation order - check the order property of the clustered index scan in the execution plan. Ordered = No is...
--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:07 am

#1004556
RE: Are the posted questions getting worse?

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" method 5 times....
--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 3, 2009 at 10:52 pm

#1004408
RE: Are the posted questions getting worse?

Back in a sec... virus software update kicked in. Wouldn't make for a fair test.
--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 3, 2009 at 9:32 pm

#1004395

Viewing 15 posts - 43,606 through 43,620 (of 59,097 total)