Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 59,085 total)

Reply To: Improving Skills at Work

JRuss wrote:
Rod at work wrote:
Last observation, we've been experiencing a lot of turnovers recently. One of the biggest positions to leave is the head of our Project Management Office. In an all-IT...
--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)

December 21, 2022 at 11:52 pm

#4128674
Reply To: Controlling the evaluation of scalar functions
cmartel 20772 wrote:
The following statement runs in 4 seconds and is definitely better:
```
SELECT
  B.ID,
  D.Value
FROM #Big B
LEFT MERGE JOIN (
  SELECT ID, dbo.GetValueInLanguage('fr', XmlValue) AS...
```
--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)
December 21, 2022 at 11:51 pm

#4128673
Reply To: Improving Skills at Work

Maybe a multi-author Stairway to make such articles easy to find as a group? To make it as high quality as possible, perhaps have a couple people do a review...
--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)

December 21, 2022 at 9:12 pm

#4128630
Reply To: Improving Skills at Work

Hmmmm.... maybe a kickoff with the most basic and, yet, one of the most important things that isn't actually taught in any beginner classes that pretty much laid a foundation...
--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)

December 21, 2022 at 9:08 pm

#4128629
Reply To: Improving Skills at Work

Agreed. Definitely not a one man show on this type of thing.
It's funny that you brought this up because I was thinking about how many things I and others have...
--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)

December 21, 2022 at 8:59 pm

#4128621
Reply To: Improving Skills at Work

That sounds like a fantastic idea, Steve. Any ideas for a series title, just to add some consistency to such articles? Some of those have already been written though. Like...
--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)

December 21, 2022 at 8:35 pm

#4128616
Reply To: Improving Skills at Work

What I find funny is that all of the too-cool-for-school stuff is what people concentrate on. They don't realize the importance of SQL because they think they know SQL... 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)

December 21, 2022 at 4:43 pm

#4128532
Reply To: get a substring value from string

carsten.saastamoinen wrote:
It is OK for me to be removed from different threads because I not agree?
Absolutely not. Where did that happen? Was it on this this thread? Was it...
--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)

December 21, 2022 at 4:06 pm

#4128512
Reply To: Updating .NET Core on SQL Server --> Dangerous?

Michael L John wrote:
Jeff Moden wrote:
Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to go...
--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)

December 20, 2022 at 11:53 pm

#4128169
Reply To: Updating .NET Core on SQL Server --> Dangerous?

Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to go through.
And glad...
--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)

December 20, 2022 at 11:33 pm

#4128166
Reply To: What's the logic of the NOT IN clause?

jcelko212 32090 wrote:
SQL FOR SMARTIES 5th edition, chapter 18.2 goes into a lot of painful details znd works it all out
Thanks, Joe!
--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)

December 20, 2022 at 11:17 pm

#4128164
Reply To: get a substring value from string

carsten.saastamoinen wrote:
Hopefully 10 seconds few times a day is a problem on you server!!!!
It's not... but the attitude that will cause everything to be written in such a fashion, or...
--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)

December 20, 2022 at 5:09 am

#4127780
Reply To: What's the logic of the NOT IN clause?

jcelko212 32090 wrote:
Yes, that is how NOT IN () is defined in ANSI/ISO Standard SQL.
Thanks for the confirmation on that, Joe. Do you happen to have a link for that or...
--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)

December 20, 2022 at 5:08 am

#4127779
Reply To: Embadded Select in another Select and using apostrophes / quotes
The way I write such code is to ...
1. Write it like normal, properly indented code.
2. Test the dickens out of it to make sure it works.
3. Doe a search...
--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)
December 20, 2022 at 12:23 am

#4127720
Reply To: Embadded Select in another Select and using apostrophes / quotes

You code appears to be a part of Dynamic SQL. If so, then replace each single quote with two single quotes.
--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)

December 19, 2022 at 11:29 pm

#4127709

Viewing 15 posts - 2,251 through 2,265 (of 59,085 total)