Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 59,069 total)

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
Reply To: Entire Row to be Unique in the whole Table...

Understood.
--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:18 am

#3927691
Reply To: hierarchy related query

Do you have the next or previous month worth of test data that we can load to do some testing with?
--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:16 am

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

Michael L John wrote:
Eirikur Eiriksson wrote:
BTW: Jeff is of course our SSIS expert 😉
Define "Expert"
Expert at avoiding the use of SSIS. 😀

--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:02 am

#3927688
Reply To: Plan Cache refreshing every 24 hours

stevec883 wrote:
You have 14182 total plans in your cache, with 100.00% plans created in the past 24 hours, 98.00% created in the past 4 hours, and 98.00% created in the...
--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:00 am

#3927687

Viewing 15 posts - 4,666 through 4,680 (of 59,069 total)