Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, January 31, 2019 1:30 PM
Ed Wagner - Thursday, January 31, 2019 12:49 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 31, 2019 at 7:15 pm

#2020798
RE: Database has no owner

Steve Jones - SSC Editor - Wednesday, January 30, 2019 11:14 AM
I don't think this is an issue. I had an AD...
--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 11:31 pm

#2020660
RE: very slow select

Tomys - Wednesday, January 30, 2019 10:48 AM
Jeff Moden - Sunday, January 27, 2019 7:24 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 30, 2019 at 11:27 pm

#2020659
RE: Trying out a trick.

Luis Cazares - Wednesday, January 30, 2019 11:23 AM
HappyGeek - Wednesday, January 30, 2019 11:06 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 30, 2019 at 10:12 pm

#2020656
RE: Trying out a trick.

Steve Jones - SSC Editor - Wednesday, January 30, 2019 11:02 AM
Seems like a not-Jeff day
Heh... more like a "not an SSC...
--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 10:11 pm

#2020655
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 9:02 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 30, 2019 at 6:10 am

#2020551
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

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