Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,031 through 12,045 (of 59,099 total)

RE: Most important DBA Skill?

This subject has come up again on another thread. It seems that a lot of people want the skill when it comes to a DBA. Others want a people person...
--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)

June 23, 2018 at 9:47 pm

#1995071
RE: When it comes to salaries, I'm not average

xsevensinzx - Saturday, June 23, 2018 5:50 AM
Jeff Moden - Saturday, June 23, 2018 4:37 AM
--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)

June 23, 2018 at 6:07 pm

#1995068
RE: When it comes to salaries, I'm not average

xsevensinzx - Friday, June 22, 2018 10:24 PM
Jeff Moden - Friday, June 22, 2018 5:50 PM
--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)

June 23, 2018 at 4:37 am

#1995054
RE: When it comes to salaries, I'm not average

Andy Warren - Friday, June 22, 2018 6:11 PM
Jeff now I get your point!
It's a tough point to "get". Thanks for 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)

June 22, 2018 at 7:31 pm

#1995047
RE: When it comes to salaries, I'm not average

@Andy... yes, I absolutely understand that. And it's all very well stated. What I'm getting at is that everyone is going to use this once they become aware of 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)

June 22, 2018 at 5:50 pm

#1995043
RE: Get first date and last date of the current month base on Work Week

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

June 22, 2018 at 3:24 pm

#1995031
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, June 22, 2018 1:20 PM
Geez, why are people coming here expecting some one here to write code for...
--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)

June 22, 2018 at 2:27 pm

#1995025
RE: How to find the all table list in the order of reference

binutb - Friday, June 22, 2018 7:21 AM
Hi,
We are using
--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)

June 22, 2018 at 6:58 am

#1994963
RE: How to find the all table list in the order of reference

binutb - Friday, June 22, 2018 2:42 AM
Hi,
Finally we can conclude, unable to find table list in creation sequential order.
Please advise any...
--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)

June 22, 2018 at 6:44 am

#1994961
RE: When it comes to salaries, I'm not average

Andy Warren - Thursday, June 21, 2018 3:10 PM
Jeff, you're right that a lot of us are average. That's not bad, it's...
--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)

June 21, 2018 at 7:50 pm

#1994932
RE: Get first date and last date of the current month base on Work Week

The problem is that that your presumption on what the current month is is incorrect. If you go back to May, the 28th should be a part of May. In...
--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)

June 21, 2018 at 6:42 pm

#1994929
RE: Split a comma separated string without looping ( No while loops )

mw_sql_developer - Thursday, June 21, 2018 10:04 AM
mw_sql_developer - Thursday, June 21, 2018 10:02 AM
--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)

June 21, 2018 at 3:10 pm

#1994921

Viewing 15 posts - 12,031 through 12,045 (of 59,099 total)