Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,571 through 30,585 (of 59,101 total)

RE: A Personality Test

GSquared (3/27/2012)
Here's why I consider professional personality tests critically flawed:
A few years back, the owner of the company I worked for decided all the employees needed to take DiSC personality...
--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)

March 27, 2012 at 8:19 pm

#1465437
RE: A Personality Test

David.Poole (3/27/2012)
GSquared (3/27/2012)
"What's 'loquacious'?" I was the only person in the room who knew what it means...
Mental note not to play Scrabble with you!
I've just told the wife...
--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)

March 27, 2012 at 7:48 pm

#1465433
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

ALZDBA (3/26/2012)
Great extrapolation of the KISS principle, Jeff.
Need it to be sead ... [font="Times New Roman"]I LOVE IT[/font] :w00t:
Thanks for the feedback, Johan. I agree... the simpler, 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)

March 27, 2012 at 7:29 pm

#1465429
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

Scott Abrants (3/26/2012)
Excellent post! Great examples, great code, and easy to follow!
Nice job Jeff!
Thanks for the feedback, Scott. I appreciate you stopping by.
--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)

March 27, 2012 at 7:27 pm

#1465428
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

dwain.c (3/26/2012)
Jeff,
The following thought occurred to me last night but I didn't get a chance to test it until this morning.
Isn't the modulo function designed to always return a positive...
--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)

March 27, 2012 at 7:11 pm

#1465426
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

Michael Valentine Jones (3/27/2012)
dwain.c (3/26/2012)
Jeff,
The following thought occurred to me last night but I didn't get a chance to test it until this morning.
Isn't the modulo function designed to always...
--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)

March 27, 2012 at 7:04 pm

#1465425
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

SQLRNNR (3/27/2012)
Thanks for the article Jeff.
Thanks for the feedback, Jason. Always good to hear from 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)

March 27, 2012 at 7:03 pm

#1465424
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

Kangana Beri (3/27/2012)
Great article! Thanks.
Thanks for the read and the feedback, Kangana. I appreciate 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)

March 27, 2012 at 7:02 pm

#1465423
RE: Howe to get unique row

SQLRNNR (3/27/2012)
Just a reminder that using DISTINCT often times is masking a bigger issue. Perhaps if you provided sample data and sample tables with your sample query, a better...
--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)

March 27, 2012 at 4:16 pm

#1465401
RE: Suggest a Data Modeling tool

Heh... to err is human. To really screw something up, you need a computer. 😛
Just remember that none of these tools guarantee a good design. The human still...
--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)

March 27, 2012 at 4:11 pm

#1465398
RE: Grouping based on contiguous dates

Eugene Elutin (3/27/2012)
...
Try adding this into the original sample data
SELECT 'Jun 1 2011 12:00AM','1','10','20' UNION ALL
The results of the two queries are different.
My query will only work if...
--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)

March 27, 2012 at 4:07 pm

#1465396
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

Sorry. Thought it was you. Must have been Peter Larsson.
Yes, we tested it and the conversion does make quite a bit of differrence.
--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)

March 27, 2012 at 3:19 pm

#1465381
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

GSquared (3/27/2012)
Here's what I was able to come up with as a sample solution. I imported your CSV file into a table called SampleData, and queried it this way:
;
WITH...
--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)

March 27, 2012 at 3:16 pm

#1465380
RE: Are the posted questions getting worse?

Lynn Pettis (3/27/2012)
GSquared (3/27/2012)
Stefan Krzywicki (3/27/2012)
It is amazing how, no matter how often I state "I am not interested in travel or relocation", when I mention that on my resume...
--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)

March 27, 2012 at 11:02 am

#1465169
RE: Are the posted questions getting worse?

GilaMonster (3/27/2012)
Is it just me, or does a term like 'That can be done, but people usually learn better' rankle when applied to something you've said?
Feels a little condescending.
I've...
--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)

March 27, 2012 at 11:00 am

#1465166

Viewing 15 posts - 30,571 through 30,585 (of 59,101 total)