Jeff Moden

Forum Replies Created

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

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
Reply To: Plan Cache refreshing every 24 hours

stevec883 wrote:
That's an interesting point. Sp_BlitzCache told me a top priority was plans being built daily, but our server is not really taxed. I will check the indexes as well....
--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 5:49 am

#3927685
Reply To: hierarchy related query

You've been around long enough to know and have been advised before (April 2020) that you need to post some real DDL for such problems. Please read'n'heed the article at...
--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 7, 2021 at 3:20 pm

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

Brandie Tarvin wrote:
And on a fun note, this site isn't loading for me in Edge either. It just serves up blank pages. Not sure what's going on with that either.
I just...
--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 7, 2021 at 3:13 pm

#3927540
Reply To: Entire Row to be Unique in the whole Table...

Jonathan AC Roberts wrote:
frederico_fonseca wrote:
depending on number of columns on that table you may need (and it may be advisable) to resort to have a hash column added and make this column...
--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 7, 2021 at 3:06 pm

#3927538
Reply To: Need Some HELP with a Query to help me validate other program.

J Livingston SQL wrote:
as a developer, I am sure you will appreciate my next question............any chance you can provide set up scripts for your tables and sample data, please...? (Not everyone is...
--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 7, 2021 at 5:57 am

#3927402

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