Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,586 through 36,600 (of 59,072 total)

RE: I need some help with a test, please.

P.S. I really want to know when you took up mind-reading, Ron. I was about to post and ask for a full run like that. Thanks.
--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)

September 20, 2010 at 4:53 pm

#1224438
RE: I need some help with a test, please.

bitbucket-25253 (9/20/2010)
Jeff using Brad Schulz blog post on using option(Force order,Maxdop 1, Loop Join).
http://bradsruminations.blogspot.com/2010/08/taking-hint.html
Again SQL Server 2008 on my bigger machine
...
--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)

September 20, 2010 at 4:51 pm

#1224437
RE: I need some help with a test, please.

Thanks Mazzz. All of these are matching up ver consistently. Tally table on 2k8 on the join as it's currently written is just absolutely crawling. I appreciate...
--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)

September 20, 2010 at 1:34 pm

#1224354
RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
It seems to me that the XML solution performs exceptionally well (and so much better than any previous XML attempt) where a single large delimited string 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)

September 20, 2010 at 12:32 pm

#1224298
RE: I need some help with a test, please.

mazzz (9/20/2010)
Jeff Moden (9/20/2010)
mazzz (9/20/2010)
Jeff
I've just seen your update in the OP - do you need any more results?
My home setup is Win 7, Intel core duo CPU, 4GB RAM,...
--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)

September 20, 2010 at 12:26 pm

#1224294
RE: I need some help with a test, please.

Brad Schulz (9/20/2010)
Jeff Moden (9/20/2010)
Brad... what do you get in 2K8 for that same test with the Trace Flag turn on?
I'm attaching it... along with the execution plan.
Thanks, Brad.
--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)

September 20, 2010 at 12:24 pm

#1224290
RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
Jeff Moden (9/20/2010)
The reason why I mention SARGable is because I believe that it might be able to do a better job at cost estimation if 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)

September 20, 2010 at 12:23 pm

#1224289
RE: Are the posted questions getting worse?

GilaMonster (9/20/2010)
*drum roll*
*trumpet crescendo*
... and I think I'll leave things here for a little while.
Edit: And as soon as i decide not to post for a few hours, there's 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)

September 20, 2010 at 11:45 am

#1224245
RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
Jeff Moden (9/20/2010)
Just to be sure, you're [font="Arial Black"]not [/font]recommending that this flag be set permanently, right? I don't want anyone to think that this should...
--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)

September 20, 2010 at 11:36 am

#1224237
RE: I need some help with a test, please.

Brad Schulz (9/20/2010)
Very interesting post from Paul regarding the Spooling and Trace 8690... If I turn that trace flag on in SQL2008, the performance improves spectacularly.
(Also, just as a note,...
--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)

September 20, 2010 at 11:32 am

#1224234
RE: I need some help with a test, please.

mazzz (9/20/2010)
Jeff
I've just seen your update in the OP - do you need any more results?
My home setup is Win 7, Intel core duo CPU, 4GB RAM, 64bit, SQL2008 R2...
--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)

September 20, 2010 at 11:28 am

#1224231
RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
It's just a 'performance spool' (sort + lazy spool combination) introduced based on inaccurate/missing statistical information. If you disable the performance spool optimization with DBCC TRACEON...
--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)

September 20, 2010 at 11:24 am

#1224227
RE: I need some help with a test, please.

Brad Schulz (9/20/2010)
Very interesting post from Paul regarding the Spooling and Trace 8690... If I turn that trace flag on in SQL2008, the performance improves spectacularly.
(Also, just as a note,...
--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)

September 20, 2010 at 11:04 am

#1224210
RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
rob.symonds (9/20/2010)
Anyone else a little concerned about the 2k8 results for the inline Tally?
The latest scripts and results simply show that the optimizer can generate a poor...
--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)

September 20, 2010 at 11:00 am

#1224206
RE: I need some help with a test, please.

ColdCoffee (9/20/2010)
Jeff, here is my test results for the AdventureWorks JOIN query you asked to give results for. this is run in my slowest environment (Env2)
Wow! 109ms CPU but...
--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)

September 20, 2010 at 10:50 am

#1224201

Viewing 15 posts - 36,586 through 36,600 (of 59,072 total)