Jeff Moden

Forum Replies Created

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

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
RE: Hierarchical query match with multiple tables

I grok your question.
First, you've been around long enough for you to start helping the people that you want help from. Please read and heed the article...
--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:16 am

#1990291
RE: Recursive with multiple first lines

ross.hughes - Friday, May 11, 2018 8:26 AM
That looks like it is working, Jeff. There was only an extra parenthesis on the...
--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 11, 2018 at 4:28 pm

#1990259
RE: Rebuilding Indexes very often is good?

WonderPra - Friday, May 11, 2018 12:44 PM
No rush but I am looking forward for you to release an article or post...
--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 11, 2018 at 4:16 pm

#1990257
RE: Prepare a stored procedure work flow diagram

To me, regurgitating the actual code as a diagram is very nearly useless, especially in SQL Server. And, to me, creating any diagram without documenting in the code itself is...
--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 11, 2018 at 11:49 am

#1990234

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