Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,631 through 36,645 (of 59,099 total)

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

Paul White NZ (9/20/2010)
mazzz (9/20/2010)
I would like to help - is the latest code that Jeff would like us to run in the original post?
My understanding is that Jeff welcomes...
--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:04 am

#1223941
RE: Query tweak required

Bhuvnesh (9/19/2010)
WayneS (9/17/2010)
Probably not what you're looking for, but how's this?
Select top 5 'MY DATABASE TABLE: ' = name
from sysobjects
where xtype = 'u'
order by 1 desc
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 19, 2010 at 11:15 pm

#1223802
RE: Put logic inside Execute SQL Task or call sproc?

Craig Farrell (9/19/2010)
My preference has, and almost always will be, SPROC if there's logic involved if I can get away with it. Primarily so that I only have 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 19, 2010 at 11:09 pm

#1223797

Viewing 15 posts - 36,631 through 36,645 (of 59,099 total)