Jeff Moden

Forum Replies Created

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

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
RE: Recursive with multiple first lines

First, what you've asked for is to determine the hierarchy of a "forest", meaning that it has more than one root and, therefor, more than 1 tree.
The type...
--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:41 pm

#1989019
RE: Recursive with multiple first lines

Having a look now... thanks for taking the time to make the data readily consumable.
--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 6:31 pm

#1989015
RE: Log file R drive- What is consuming it

So, did you ever find the offending transaction?
--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 6:23 pm

#1989013

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