Jeff Moden

Forum Replies Created

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

RE: Performance Question

Budd - Wednesday, May 16, 2018 7:35 AM
Hi,
I have much more to learn than to teach, but I have a habit of...
--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 16, 2018 at 7:55 am

#1990661
RE: Creating Filters like Previous Week, from Tuesday to Monday

kyagi.jo - Wednesday, May 16, 2018 3:49 AM
Hi,
If I needed to create some kind of filter that would get the data between...
--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 16, 2018 at 5:33 am

#1990632
RE: Where Waits coming from?

Yuri55 - Tuesday, May 15, 2018 6: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)

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

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