Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,371 through 14,385 (of 59,097 total)

RE: Determine Monday of next month and Monday of next week

ScottPletcher - Thursday, September 7, 2017 1:59 PM
jcelko212 32090 - Thursday, September 7, 2017 1:40 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)

September 8, 2017 at 8:59 pm

#1958829
RE: Convert this SQL Agent Job Step to Powershell

Why on earth do you want to convert it to PowerShell, which is really not much more than a CLI to begin 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)

September 8, 2017 at 4:24 pm

#1958819
RE: Using Tools that Fit

Andy Warren - Friday, September 8, 2017 3:56 PM
I was just re-reading the replies and enjoying the diversity of perspectives. The comment...
--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 8, 2017 at 4:21 pm

#1958818
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Friday, September 8, 2017 10:06 AM
No, of course not. This information is part of my daily run of checks 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)

September 8, 2017 at 3:00 pm

#1958810
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Wednesday, April 5, 2017 9:01 AM
Jeff, i tend to disagree.
If you want to get the actual usage information (via fileproperty...
--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 8, 2017 at 9:58 am

#1958753
RE: To automatically change the value of a column if a particular date time is reached

You're welcome but it's not just me. A lot of good people on this thread made similar suggestions.
--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 8, 2017 at 9:48 am

#1958752
RE: Using Tools that Fit

I'm looking forward to having a couple/three large monitors at home (not so much at work... people shouldn't see what I'm doing). I'll work on one in the middle and...
--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 8, 2017 at 9:46 am

#1958751
RE: Are the posted questions getting worse?

Chris Harshman - Friday, September 8, 2017 6:54 AM
Jeff Moden - Thursday, September 7, 2017 6:06 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)

September 8, 2017 at 9:43 am

#1958750
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, September 8, 2017 5:32 AM
Fellow Threadizens!
Today is my last day of work before Red Gate makes me take...
--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 8, 2017 at 9:36 am

#1958748
RE: Are the posted questions getting worse?

Tom_Hogan - Friday, September 8, 2017 9:01 AM
Lynn Pettis - Thursday, September 7, 2017 3:53 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)

September 8, 2017 at 9:33 am

#1958747
RE: Determine Monday of next month and Monday of next week

jcobb 20350 - Thursday, September 7, 2017 4:07 PM
Jeff Moden - Wednesday, September 6, 2017 4:19 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)

September 8, 2017 at 9:30 am

#1958745
RE: Today's Random Word!

TomThomson - Thursday, September 7, 2017 8:56 PM
ManicStar - Thursday, September 7, 2017 10:06 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)

September 7, 2017 at 9:39 pm

#1958674
RE: To automatically change the value of a column if a particular date time is reached

gvoshol 73146 - Tuesday, September 5, 2017 5:47 AM
Tables don't "automatically update" by themselves. (Egad, would that be a mess if they...
--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 7, 2017 at 9:35 pm

#1958672
RE: To automatically change the value of a column if a particular date time is reached

poornima.s_pdi - Tuesday, September 5, 2017 2:19 AM
Are you asking me to use view or storedprocedure? If it is a view, 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 7, 2017 at 9:27 pm

#1958671
RE: Replace the first charatcer in a String

Avi1 - Thursday, September 7, 2017 7:33 AM
please give some sample data and expected result
My understanding is you want to change first...
--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 7, 2017 at 8:32 pm

#1958668

Viewing 15 posts - 14,371 through 14,385 (of 59,097 total)