Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 59,067 total)

Reply To: Are the posted questions getting worse?

Just for fun, -40 degrees is where the Celsius and Fahrenheit scales cross.
--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 23, 2022 at 5:10 pm

#4129468
Reply To: The 12 days of Christmas

BTW... the documentation for the subject of "trailing blanks" NOT being included in comparisons is a bit difficult to find. You would think that MS would have included it 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 23, 2022 at 4:30 pm

#4129442
Reply To: The 12 days of Christmas

Ok... bloody variable width font's made it look like the CHARINDEX was based on an Empty String and not a single space, so I did have a misleading bit 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)

December 23, 2022 at 3:25 pm

#4129399
Reply To: The 12 days of Christmas

Sorry... Had an possible error in my post and took it down until I'm sure.

--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 23, 2022 at 2:48 pm

#4129377
Reply To: Log Size is too high

Arsh wrote:
Hi Friends,
I have been assigned to manage an SQL server pool with some standalone and with Log shipped to a DR. I noticed one of them has two databases...
--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 22, 2022 at 7:48 pm

#4129050
Reply To: Trouble with date values

@krypto69 ...
Ah... maybe not enough coffee when I read it the first time and assumed that "just goes and goes and returns no records" meant that it never stops.
Just 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)

December 22, 2022 at 7:20 pm

#4129041
Reply To: Trouble with date values

Have you checked to see if the d.eff_thru column is actually NULLable?
If it's not, remove the ISNULL from your formula.
If it IS NULLable, the ISNULL formula is non-SARGable (basically, cannot...
--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 22, 2022 at 6:00 pm

#4129031
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

Viewing 15 posts - 2,221 through 2,235 (of 59,067 total)