Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,421 through 12,435 (of 59,102 total)

RE: Number of Days between two Day Names

ScottPletcher - Friday, May 4, 2018 11:19 AM
Why the need to over-engineer everything? Each entry is, for example, "Wednesdays" not a specific...
--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)

May 4, 2018 at 3:00 pm

#1989356
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 6:10 PM
Jeff Moden - Thursday, May 3, 2018 5:32 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)

May 4, 2018 at 7:51 am

#1989282
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 4:32 PM
yes there is. I think you're misunderstanding the day of week problem. 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)

May 3, 2018 at 5:32 pm

#1989213
RE: Scripting Objects with PowerShell

Sergiy - Thursday, May 3, 2018 5:02 PM
It looks like awful amount of manual work / human analysis involved for every object...
--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)

May 3, 2018 at 5:26 pm

#1989212
RE: Scripting Objects with PowerShell

qbrt - Thursday, May 3, 2018 9:17 AM
This is a great intro to this workflow. And I agree that each developer should...
--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)

May 3, 2018 at 5:20 pm

#1989211
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 3:38 PM
Jeff Moden - Thursday, May 3, 2018 2:32 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)

May 3, 2018 at 4:15 pm

#1989205
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 12:32 PM
Jeff Moden - Thursday, May 3, 2018 11:58 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)

May 3, 2018 at 2:32 pm

#1989192
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 11:20 AM
Jeff Moden - Thursday, May 3, 2018 11:15 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)

May 3, 2018 at 11:58 am

#1989136
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Thursday, May 3, 2018 5:00 AM
Jeff Moden - Wednesday, May 2, 2018 4:43 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)

May 3, 2018 at 11:15 am

#1989123
RE: Proxy account not working in stored procedure

Ok... this is all going the wrong way. NEVER NEVER NEVER grant privs to any user or application login to execute xp_CmdShell directly! NEVER! If they need to do something...
--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)

May 3, 2018 at 11:12 am

#1989121
RE: Upper Case Lower Case

jonathan.crawford - Thursday, May 3, 2018 8:33 AM
Jeff Moden - Wednesday, May 2, 2018 7: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)

May 3, 2018 at 11:08 am

#1989118
RE: Recursive with multiple first lines

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

May 2, 2018 at 9:30 pm

#1989025
RE: Script out EXISTING database mail profile's settings

terry.home - Wednesday, May 2, 2018 3:24 PM
Excuse my ignorance, not having used 2016 yet in anger, why would you need 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)

May 2, 2018 at 8:52 pm

#1989022
RE: Upper Case Lower Case

Jason A. Long - Wednesday, May 2, 2018 7:35 PM
Jeff Moden - Wednesday, May 2, 2018 4:47...
--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)

May 2, 2018 at 8:51 pm

#1989021
RE: Proxy account not working in stored procedure

jack_walker - Wednesday, May 2, 2018 1:40 PM
I have a stored procedure that uses xp_cmdshell to copy a file from one folder...
--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)

May 2, 2018 at 8:47 pm

#1989020

Viewing 15 posts - 12,421 through 12,435 (of 59,102 total)