Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,111 through 49,125 (of 59,093 total)

RE: The IT Employee Benchmark

You're a very wise man, Mr. Jones. You sure I can't come to work for you? 😛
--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)

July 22, 2008 at 1:04 pm

#846651
RE: SELECTing a sample

Heh... now that there's some funny stuff Mr. Young! 😛
--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)

July 22, 2008 at 1:01 pm

#846650
RE: Return the most frequent value

Christopher Stobbs (7/22/2008)
HI All,
Wow this has been fun:
I have tested all the solutions with 1Mil rows of Jack's Data and here is what happened:
Not trying to take anything away form...
--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)

July 22, 2008 at 9:09 am

#846462
RE: Return the most frequent value

Jack Corbett (7/22/2008)
I could make excuse, but stupidity is no excuse (I obviously needed to read up on Order By):D. Here is what I came up with to fix...
--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)

July 22, 2008 at 8:06 am

#846424
RE: Return the most frequent value

Christopher Stobbs (7/22/2008)
I've run yours and mine aagainst a 1mil rows and it seems
Results
Mine:
SQL Server Execution Times:
CPU time = 4219 ms, elapsed time = 9937 ms.
Yours:
SQL...
--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)

July 22, 2008 at 8:02 am

#846420
RE: The IT Employee Benchmark

jburkman (7/22/2008)
It's why every IT department should have one or two openings permanently available in case someone that's really valuable comes along. Identifying that person can be hard, and 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)

July 22, 2008 at 7:43 am

#846410
RE: The IT Employee Benchmark

James Stover (7/22/2008)
Accounting says: IT = cost center.
Shareholder says: maximize profits.
CIO says: freezing wages; outsourcing 1/2 the team.
And I'm supposed to be enthusiastic about this?
When it comes to losing good...
--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)

July 22, 2008 at 7:37 am

#846406
RE: Return the most frequent value

Chris Morris (7/22/2008)
Top work, Jeff! It looks so much nicer in SQL2k5.
Top work yourself, Chris... it was a real bugger to pull off using 2k code, but you did 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)

July 22, 2008 at 7:30 am

#846399
RE: Return the most frequent value

Chris Morris (7/22/2008)
I think this works but gosh it's pretty horrible...
It would take another aggregated SELECT to bring in MAX or MIN DM_Source_Id.
Of course this is a SQL2k5 forum section...
Thank...
--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)

July 22, 2008 at 7:17 am

#846390
RE: SELECTing a sample

Perfect and good idea. Thanks for sharing the background of this problem. 🙂
--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)

July 22, 2008 at 6:30 am

#846354
RE: Pls help to solve this query

Now that's an interesting use... I normally just use an inner tube sling shot with a foot wide maw on 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)

July 22, 2008 at 6:22 am

#846344
RE: UDF execution through a CLR

Thanks for the feedback.
--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)

July 22, 2008 at 6:20 am

#846342
RE: Handling Tempdb space full situtation?

We also need to know what you think "full" is... how many bytes is your TempDB?
--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)

July 22, 2008 at 6:18 am

#846339
RE: Given an employee table( with columns Emp_ID,Emp_Name,Emp_Salary), how would you find out the fifth highest salary?

Dang... you're right Lynn... I was blazing through a bunch of these and didn't read all the posts. My appologies. Thanks for the feedback.
--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)

July 22, 2008 at 6:15 am

#846333
RE: Soft Skills

Matt Miller (7/21/2008)
Jeff Moden (7/21/2008)
I'm walking into a new job similar to that on Monday...
I keep trying to look at the bright side. The ETL is process some 10,000...
--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)

July 22, 2008 at 6:12 am

#846331

Viewing 15 posts - 49,111 through 49,125 (of 59,093 total)