Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,601 through 36,615 (of 59,072 total)

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

Jeff Moden (9/20/2010)
HowardW (9/20/2010)
Where's the rest of it for your machine?
In my previous post... 🙂
heh... yeah... I saw that right after I posted. Thanks Howard. Interesting...
--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:11 am

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

HowardW (9/20/2010)
Where's the rest of it for your machine?
In my previous post... 🙂
heh... yeah... I saw that right after I posted. Thanks Howard. Interesting on how...
--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:10 am

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

Ok folks... I'm pretty sure we've collectively narrowed down the problem. For those of you who have 2k8, especially Ron, Paul, and Howard (because you've all submitted runs that...
--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 6:55 am

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

bitbucket-25253 (9/20/2010)
Results using the Brad Schulz (as posted by Jeff)
Again SQL 2005 and SQL 2008 on the larger faster machine, and SQL2005 Express on the smaller slower box.
Whoa! That...
--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 6:50 am

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

mazzz (9/20/2010)
Hi Jeff
I'm unable to run the second script as the servers I can use here do not have AdventureWorks installed. I will run the second one from my home...
--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 6:45 am

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

Jeff Moden (9/20/2010)
HowardW (9/20/2010)
There you go (Same SS2k8 SP1 Quad-Core as previous post):
--===== Split8KTally mlTVF ===========================================================================================
SQL Server Execution Times:
CPU time = 0 ms, elapsed time...
--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 6:38 am

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

Paul White NZ (9/20/2010)
Jeff Moden (9/19/2010)
Would some of you other good folks run this code and post the results please? We need both 2k5 and 2k8 runs for anyone...
--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 6:36 am

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

HowardW (9/20/2010)
There you go (Same SS2k8 SP1 Quad-Core as previous post):
--===== Split8KTally mlTVF ===========================================================================================
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0...
--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 6:32 am

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

rob.symonds (9/20/2010)
Anyone else a little concerned about the 2k8 results for the inline Tally?
It's not the Tally table in 2k8. We'd have seen a similar problem in all the...
--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 6:30 am

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

Mark-101232 (9/20/2010)
More results attached, this time on a server.
Also SQLCLR figures are this
Tally:
Table 'Tally'. Scan count 10000, logical reads 30000, physical reads 0
Table 'CsvTest'. Scan count 1, logical reads 774,...
--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 6:24 am

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

steve-893342 (9/20/2010)
Jeff Moden (9/19/2010)
Yowch... I just tried XML-3 in a 1000 row by 1000 element test rig... not good. I stopped the run after two hours. Needless to...
--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 6:14 am

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

ColdCoffee (9/19/2010)
Jeff, here are the other 3 environment's results (Note : This result set is not the results of the AdventureWorks JOIN code test rig ; this is of the...
--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 6:12 am

#1223947

Viewing 15 posts - 36,601 through 36,615 (of 59,072 total)