Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 59,098 total)

Reply To: large table cleanup using Delete

Bruin wrote:
Sorry did my Insert wrong should not contain the NULL string should be blank..
No... not blank... it should contain the word NULL without quotes. So go back and fix...
--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)

September 10, 2021 at 5:34 pm

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

You have your own odel and that's fine. What I took exception to was your passive aggressive and highly judgemental mouth saying such condescending things like you being personalty embarrassed...
--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)

September 10, 2021 at 5:15 pm

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

Steve Jones - SSC Editor wrote:
If you continue to view that image or title as discriminatory or exclusionary for white people, and that's the unintended consequence, I'm not sure if I can explain...
--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)

September 10, 2021 at 12:11 am

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

Please don't take it upon yourself to be personally embarrassed for me. You've take everything I've stated and twisted it to mean the exact opposite of what I mean.
--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)

September 9, 2021 at 11:41 pm

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

Steve Jones - SSC Editor wrote:
Is holding a conference focused on black/Latin groups discriminatory? I suppose it could be seen that way if it only allowed black or Latin attendees/speakers/etc. In the description 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)

September 9, 2021 at 8:52 pm

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

Hugo Kornelis wrote:
You want to attack organizers of tech events that target women, people of colour, or other under-represented groups? Then better come prepared with strong arguments to convince the world...
--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)

September 9, 2021 at 1:50 pm

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

Brandie Tarvin wrote:
Completely missing the point, Phil.
It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender...
--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)

September 9, 2021 at 1:28 pm

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

Greg Edwards-268690 wrote:
I view some events like in a bit different light. They serve as inspiration for others to see and believe they can be successful. I doubt many presenting 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)

September 9, 2021 at 8:00 am

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

Can someone tell me why this isn't horribly racially prejudiced?
https://www.eventbrite.com/e/black-is-tech-conference-2021-tickets-149570987851
Can I open a "White Is Tech" conference without any ramifications? I never would, though. THAT would be racist.
Can 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)

September 8, 2021 at 9:32 pm

#3928019
Reply To: The Leaves Are Changing, But Why?

If you actually believe that it's a worthwhile endeavor, don't give up. Just don't let it be all consuming. You might be surprised what kind of proof you can come...
--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)

September 8, 2021 at 1:59 pm

#3927890
Reply To: Plan Cache refreshing every 24 hours

So, to ask the question, have you stopping the nightly index runs even for just one night to help you make an assessment?
--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)

September 8, 2021 at 1:55 pm

#3927888
Reply To: Assign multiple fields to one variable

Jeepisfun wrote:
Hi
I need to write a query / procedure that will create the following string -
Column1Name=Column1Value;Column2Name=Column2Value...etc
I have no clue on how to do that with sql. In c# or vb.net...
--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)

September 8, 2021 at 1:42 pm

#3927880
Reply To: CTE to determine Course Level

j-1064772 wrote:
I found this example very useful.
I do have a question regarding the efficiency of using recursion. Even though is get rids of explicit loops, does it result in triangular...
--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)

September 8, 2021 at 1:36 pm

#3927873
Reply To: hierarchy related query

@sqlenthu 89358
Isn't it amazing how quick people can provide an answer when they actually have data to help them understand the problems and they have a place to test some...
--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)

September 8, 2021 at 1:18 pm

#3927856
Reply To: The Leaves Are Changing, But Why?

Rod at work wrote:
I'm churning at trying to find evidence for the efficacy of following good CI/CD practices.
As tedious and disappointing as that all is for you, I don't see 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)

September 8, 2021 at 6:35 am

#3927692

Viewing 15 posts - 4,696 through 4,710 (of 59,098 total)