Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,751 through 9,765 (of 59,091 total)

RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, February 27, 2019 10:36 AM
Jeff Moden - Wednesday, February 27, 2019 8:03 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)

February 27, 2019 at 1:39 pm

#2023131
RE: Migrating jobs does not create the maintenance plans

keanyukas - Wednesday, February 27, 2019 6:33 AM
Is there a way to migrate maintenance plans
Yes. Please see the following link. ;-)...
--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)

February 27, 2019 at 8:24 am

#2023081
RE: Are the posted questions getting worse?

ZZartin - Wednesday, February 27, 2019 6:26 AM
Jeff Moden - Wednesday, February 27, 2019 5:31 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)

February 27, 2019 at 8:03 am

#2023078
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Wednesday, February 27, 2019 5:54 AM
Jeff Moden - Monday, February 25, 2019 12:16 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)

February 27, 2019 at 8:01 am

#2023077
RE: How to determine what percent of a varchar column is a valid numeric?

allan.ford17 - Tuesday, February 26, 2019 7:38 PM
I have a data profiling type of question :
I'm interesting in a query to determine...
--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)

February 27, 2019 at 7:36 am

#2023075
RE: How to determine what percent of a varchar column is a valid numeric?

Grant Fritchey - Wednesday, February 27, 2019 1:40 AM
Personally, I don't put numbers in varchar if I want them to be numbers....
--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)

February 27, 2019 at 7:31 am

#2023074
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, February 27, 2019 4:40 AM
Since when is an email address PII? Even associated with a name, how...
--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)

February 27, 2019 at 5:31 am

#2023063
RE: How To Open Bak File In Sql Server Management Studio?

sqlhidir - Tuesday, February 26, 2019 4:59 PM
Jeff Moden - Tuesday, February 26, 2019 2:15 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)

February 26, 2019 at 8:34 pm

#2023042
RE: How To Open Bak File In Sql Server Management Studio?

Nah... no question here. It's a form of semi-helpful spam to get people to go see someone's blog.
--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)

February 26, 2019 at 2:15 pm

#2023017
RE: Are the posted questions getting worse?

Thanks, folks. I really appreciate the condolences and well wishes. You've gotta love this community. You're all like a second family.
--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)

February 26, 2019 at 6:03 am

#2022958
RE: Are the posted questions getting worse?

Thanks for the well wishes. I'm OK. Mom had a good run.
--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)

February 25, 2019 at 1:06 pm

#2022903
RE: Encrypting All Procedures in a Database

haichells - Friday, February 22, 2019 11:34 PM
Dear All,
I have a requirement where i need to encrypt all my stored procedures 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)

February 25, 2019 at 12:23 pm

#2022890
RE: Are the posted questions getting worse?

Must be something in the air. My Mom died Friday. I've been ready for it for a couple of years and it's actually a blessing in disguise for the old...
--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)

February 25, 2019 at 12:16 pm

#2022886
RE: A Good Benefit?

I don't know about other folks but, because of the nature of my job, I get very little time to take off. I think companies should be required to pay...
--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)

February 25, 2019 at 8:19 am

#2022843
RE: SQL Server Database Administrator Interview Questions

Brandie Tarvin - Monday, February 25, 2019 4:49 AM
Wow, Lowell, I'm not sure I'd be too confident of myself after getting all...
--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)

February 25, 2019 at 8:17 am

#2022842

Viewing 15 posts - 9,751 through 9,765 (of 59,091 total)