Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,586 through 6,600 (of 59,072 total)

Reply To: Location Data Privacy

bestofphx wrote:
Yep. This is why I use a dumb phone. Less distraction and none of my data is being used. Wonderful.
Interesting. What is the make and model of the dumb...
--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)

August 17, 2020 at 1:24 am

#3780883
Reply To: Are the posted questions getting worse?

On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how...
--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)

August 16, 2020 at 8:44 pm

#3780835
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
And here I was thinking that
0x383338313736
8 3 8 1 7 6
was far too obvious of a hint
😎
It absolutely was obvious... it just couldn'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)
August 16, 2020 at 8:42 pm

#3780834
Reply To: How to compare strings by letters in certain places

Jason A. Long wrote:
Just for the fun of it, I decided to change it up so that will identify all of the position/character matches and tell you what the positions are 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)

August 16, 2020 at 4:35 am

#3780764
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
Thank you, Jeff!
You bet. Thank you for the feedback on what this is going to be used for.
--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)

August 16, 2020 at 3:33 am

#3780757
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
Jeff Moden wrote:
Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
```
 SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));

--=====...
```
--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)
August 15, 2020 at 10:25 pm

#3780749
Reply To: Job that runs slow how to use more CPU

sqlfriend wrote:
Thanks. This overnight update process is a part of a big project we had and hired several contract developers and project team. The web service/applications does very complicated 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)

August 15, 2020 at 10:20 pm

#3780748
Reply To: CONCATE_WS Not Recognizable

christoph.kauflin wrote:
Thanks, my bad. I am a little embarrassed. I somehow misread and had 2012 or 2008 in the back of my mind. But I also think that the tool-tip...
--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)

August 15, 2020 at 10:13 pm

#3780743
Reply To: Location Data Privacy

From the Article: I can't quite think of why I dislike this, but I do.
I can... I bought and paid for a device for my personal use. Any and all...
--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)

August 15, 2020 at 10:07 pm

#3780742
Reply To: How to compare strings by letters in certain places

Jason A. Long wrote:
Jeff Moden wrote:
Heh... it's amazing how similar that is to the code I wrote (still holding out on that because I really am curious what the end game is for...
--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)

August 15, 2020 at 8:12 pm

#3780737
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
Jeff Moden wrote:
BOR15K wrote:
I need some basic help, which I will then try to extend, please.
Since very few people ever come back to tell us, I'll make you a...
--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)

August 15, 2020 at 7:46 pm

#3780731
Reply To: How to compare strings by letters in certain places

Post deleted... I didn't see the OP's previous post that had the answer I was looking for.

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

August 15, 2020 at 7:33 pm

#3780727
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
```
 SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));

--===== Or, if...
```
--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)
August 15, 2020 at 5:32 am

#3780666
Reply To: Are the posted questions getting worse?

Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
My brain has melted this previous week so I'm having a hard time with it.
In that same spirit, what...
--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)

August 15, 2020 at 5:20 am

#3780665
Reply To: Are the posted questions getting worse?

Lynn Pettis wrote:
I have a little bit of good news, sort of. I have managed to find work at Parsons that has extended my stay to the end of September. Better...
--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)

August 15, 2020 at 5:16 am

#3780664

Viewing 15 posts - 6,586 through 6,600 (of 59,072 total)