Jeff Moden

Forum Replies Created

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

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
RE: Log backup chain

I know this post is old but why the heck does a user have enough privs to backup a database? Such things can affect more than just your log file...
--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:09 pm

#1989011
RE: Recursive with multiple first lines

If you could post some readily consumable data (see the first link in my signature line below under "Helpful Links" for how to do that), I'd be happy to scribe...
--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 4:56 pm

#1989008
RE: Upper Case Lower Case

I'm seriously missing it in the thread above. What "small change" did Luis make?
--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 4:47 pm

#1989007
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Wednesday, May 2, 2018 2:56 PM
Jeff Moden - Tuesday, May 1, 2018 10:04 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 2, 2018 at 4:43 pm

#1989006

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