Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,901 through 9,915 (of 59,093 total)

RE: Who made that change which caused the job to fail? Everyone said "Not me....."

Grant Fritchey - Wednesday, January 30, 2019 4:47 AM
How is the SSIS package run? If it's run from within SQL Server, meaning...
--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)

January 30, 2019 at 6:04 am

#2020550
RE: Reserved Space

Heh... but "diskspace is cheap", right? (One of my least favorite justifications for not fixing bad code or process).
--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)

January 29, 2019 at 10:56 pm

#2020523
RE: Can stored procedures return/output a value like a function can?

michael.leach2015 - Tuesday, January 29, 2019 10:40 PM
Sue_H - Tuesday, January 29, 2019 5: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)

January 29, 2019 at 10:51 pm

#2020522
RE: Purpose of SELECT before a calcuating the value of a function's return variable

Would you post your original code as code as a graphic so that I don't have to type it out, please> Thanks.
--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)

January 29, 2019 at 10:45 pm

#2020521
RE: Trying out a trick.

Deleted
--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)

January 29, 2019 at 10:12 pm

#2020518
RE: Bending strings

I look back at this request every once in a while and I also look back at the original request that inspired it and, maybe I'm just tired tonight, but...
--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)

January 29, 2019 at 9:54 pm

#2020517
RE: Trying out a trick.

Jeff Moden - Tuesday, January 29, 2019 9:25 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)

January 29, 2019 at 9:28 pm

#2020516
RE: Trying out a trick.

Ok, that didn't work out worth a hoot.
--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)

January 29, 2019 at 9:27 pm

#2020515
RE: Sanity check: developers storing ad-hoc production backups on their workstations

scareddba - Monday, January 28, 2019 12:31 AM
Our team of eight developers stores ad-hoc production database backups on their workstations. Some 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)

January 29, 2019 at 9:13 pm

#2020514
RE: Database has no owner

Andrew_Robertson - Tuesday, January 29, 2019 8:25 PM
I have gone into the properties of a couple of databases and noticed that under...
--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)

January 29, 2019 at 8:53 pm

#2020510
RE: Why doesn't a stored procedure prompt a user to enter parameters when parameters have been defined in the stored procedure?

michael.leach2015 - Tuesday, January 29, 2019 8:29 PM
Lynn Pettis - Tuesday, January 29, 2019 5:11 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)

January 29, 2019 at 8:50 pm

#2020509
RE: Versatile or Jack of all trades

TomThomson - Tuesday, January 22, 2019 12:19 PM
Jeff Moden - Tuesday, January 22, 2019 11:02 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)

January 29, 2019 at 7:53 pm

#2020503
RE: SQL agent job running status

sqlfriends - Tuesday, January 29, 2019 4:24 PM
I am running the SQL job, there is a pop up window telling me 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)

January 29, 2019 at 7:48 pm

#2020502
RE: Coding for Failure? Or Just Planning for Issues?

I agree with what the others have said but I just call it "Bullet-Proofing".
--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)

January 29, 2019 at 7:40 pm

#2020501
RE: Question on Grouping -Working number of days

To emphasize the problem that Drew brings up...
First_Value can certainly used to solve the given problem but it won't correctly solve the problem that will occur if there's...
--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)

January 29, 2019 at 7:24 pm

#2020498

Viewing 15 posts - 9,901 through 9,915 (of 59,093 total)