Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,346 through 12,360 (of 59,099 total)

RE: Mind Boggling query.

defineamol - Tuesday, May 15, 2018 7:14 PM
Thanks so much Jeff Moden. I appreciate the response. You are the best. 🙂
Thank your...
--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 15, 2018 at 7:38 pm

#1990619
RE: Storing multiple variations of the same data?

xsevensinzx - Tuesday, May 15, 2018 1:43 PM
Jeff Moden - Tuesday, May 15, 2018 11:59 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 15, 2018 at 2:44 pm

#1990604
RE: DeadLock --trying to figure out what resource-list is telling me?

I could be wrong (because I can't see the code in the views) but I believe I can summarize the source of the problem in 4 words... "Distinct", "Views", and...
--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 15, 2018 at 12:11 pm

#1990582
RE: Storing multiple variations of the same data?

Personally, I think it's a totally unnecessary duplication of data and it doesn't stop at just what is visible in the table. It's also likely that the same people that...
--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 15, 2018 at 11:59 am

#1990577
RE: Openrowset update issue

There is no way possible that I'd ever allow code to exist that had the user name and password in clear text.
--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 15, 2018 at 11:37 am

#1990572
RE: Are the posted questions getting worse?

ChrisM@Work - Tuesday, May 15, 2018 7:05 AM
Ed Wagner - Friday, May 11, 2018 5:32 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 15, 2018 at 7:23 am

#1990510
RE: Interviewing Avatars

Steve Jones - SSC Editor - Tuesday, May 15, 2018 3:48 AM
It's not you interviewing 1000 people, it's the candidate that applies...
--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 15, 2018 at 6:58 am

#1990505
RE: Mind Boggling query.

Try this. I don't have your complete data set so I don't exactly know what the performance will be but these types of things can be amazingly quick. Don't sweat...
--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 14, 2018 at 11:29 pm

#1990451
RE: Interviewing Avatars

Steve Jones - SSC Editor - Monday, May 14, 2018 11:55 AM
Avatars aren't useful for in-depth work, and I hope they aren't....
--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 14, 2018 at 8:50 pm

#1990444
RE: Are the posted questions getting worse?

jonathan.crawford - Monday, May 14, 2018 4:25 PM
I have this query that uses the same code over and over and I'm thinking...
--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 14, 2018 at 8:41 pm

#1990442
RE: Are the posted questions getting worse?

jonathan.crawford - Monday, May 14, 2018 4:23 PM
Anybody going to be at sqlsaturday 736 in Columbus?
I'm getting ready to submit a dual...
--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 14, 2018 at 8:36 pm

#1990441
RE: Hierarchical query match with multiple tables

autoexcrement - Monday, May 14, 2018 4:09 PM
LOL @ "not to go 'All Celko' on you"!
😀
--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 14, 2018 at 8:33 pm

#1990440
RE: Interviewing Avatars

I won't be interviewing any avatars. My personal opinion is that they'd be even worse than phone interviews. You know the ones I'm talking about... the ones where you ask...
--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 14, 2018 at 11:04 am

#1990378
RE: Hierarchical query match with multiple tables

Gaja - Sunday, May 13, 2018 1:32 PM
Thanks for replay man.
you got it right this DB design is not up 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 14, 2018 at 8:13 am

#1990346
RE: Mind Boggling query.

Also, help us help you when we finally determine what you're actually asking. Please see the article at the first link under "Helpful Links" in my signature line below. 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)

May 13, 2018 at 11:46 am

#1990292

Viewing 15 posts - 12,346 through 12,360 (of 59,099 total)