Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,616 through 36,630 (of 59,099 total)

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
RE: I need some help with a test, please.

Thanks Howard and Ron. The only datatype mismatch I'm seeing is in the code itself where there's a conversion in the join...
from dbo.Split8KTally(@CSVList,',') a
join AdventureWorks.Sales.SalesOrderDetail d on [font="Arial Black"]cast(a.ItemValue...
--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 7:44 am

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

Crud... I'm going to have to load 2K8 to actually troubleshoot this problem. I'm off to work. I'll try to load 2k8 tonight. Wish me luck. 😉
--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 7:18 am

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

HowardW (9/20/2010)
Let me know if I've missed any options that you need:
Howard, can you confirm that's from a 2K8 Version of Adventure works? 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 7:13 am

#1223994

Viewing 15 posts - 36,616 through 36,630 (of 59,099 total)