Jeff Moden

Forum Replies Created

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

RE: UDF execution through a CLR

OK... maybe I'm missing something, but why would you want to do that with a CLR? :blink:
--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 23, 2008 at 6:13 am

#846949
RE: The IT Employee Benchmark

Anirban Paul (7/23/2008)
Certificate are easily earned but knowledge not. You have to work hard for knowledge not that hard for certificate. 🙂
That pretty much summarizes my feelings about certificates...
--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 23, 2008 at 6:09 am

#846945
RE: The IT Employee Benchmark

Wayne West (7/22/2008)
The Code markup codes are also pretty cool. I'd like to know how people do the scrolling boxes, though. :hehe:
Those are done using the "code" IFCodes... when...
--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 23, 2008 at 6:08 am

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

Sorry Gus, I have no idea what ORLY means...
--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 23, 2008 at 6:03 am

#846943
RE: Dumb Question

Lot's of good stuff there Gus... I just don't think any of it needs to audit the original insert... 🙂
--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 3:20 pm

#846726
RE: Return the most frequent value

Thanks, Jack... must've been some latte in my coffee or sumthin':P
--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 3:17 pm

#846725
RE: Return the most frequent value

Heh... that's what I was getting at... none of the methods has a huge advantage over the other which means it all becomes a personal preference for readability and understanding.
On...
--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:11 pm

#846658
RE: Dumb Question

I guess I don't understand why you would need to log the insert... if no changes occur at all, the original data is still available in the original table.
--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:08 pm

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

He was talking about me blazing through posts and missing stuff...:)
--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:05 pm

#846653
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

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