Jeff Moden

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 59,095 total)

Reply To: The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

How many core did the system you tested this on 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)

June 23, 2025 at 7:49 pm

#4612111
Reply To: Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden

SwePeso wrote:
Please send me a pdf if possible.
The pre-aggregation sounds familiar
It should sound familiar. You've reviewed this slide deck before. I've made some modifications but, as before, I've mentioned 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)

June 16, 2025 at 10:56 pm

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

This post is just a test to see what the response time of processing a post is now...

--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)

June 16, 2025 at 10:51 pm

#4608631
Reply To: average duration increasing inline with exec counts

simon_s wrote:
As the title says , I've got a handful of stored procs where the avg duration rises and falls pretty much mirroring the exec count. I've looked to see...
--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)

June 13, 2025 at 2:35 pm

#4607139
Reply To: How do I add all the values in the column considering it to be in hh:mm:ss:ms

satnam.singh 44358 wrote:
How do I add all the values in the column considering it to be in hh:mm:ss:ms
Please help.
WHAT is the datatype of the column? If it's character based, what 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)

June 13, 2025 at 2:26 pm

#4607127
Reply To: Helping Students with a Data Professional Career

One of the things that most courses do NOT teach is how to rapidly create Random Constrained Data in the form of test tables and, perhaps, significant row counts 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)

June 4, 2025 at 8:41 pm

#4602707
Reply To: what etl tool are folks moving toward?

Bump to overcome the new-page post missing bug with this site.
--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)

May 21, 2025 at 2:10 am

#4594359
Reply To: what etl tool are folks moving toward?

I'm not moving towards any "ETL Tool". We've been doing major imports of millions of rows of data using BULK INSERT and we do exports using BCP. The exception 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)

May 21, 2025 at 2:07 am

#4594358
Reply To: varbinary column making select longer

To be clear... your query without including the VARBINARY might be returning 20 bytes per row and then you can't understand why it takes about twice as long to return...
--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)

May 16, 2025 at 1:00 am

#4591908
Reply To: How Helpful is a GenAI Copilot

From the article:
"The headline says that the staff rated the GenAI less useful than expected. Those last two words are interesting because your expectations shape a lot of how 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)

May 8, 2025 at 2:11 pm

#4589067
Reply To: ERROR: The requested OLE DB Provider Microsoft.ACE.OLEDB.16.0 is not registered

I just use the 64 bit version and install it in the QUIET mode.
--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)

May 6, 2025 at 2:32 am

#4588110
Reply To: Interview Tips

Eric M Russell wrote:
I think it's important to familiarize with the current boilerplate questions that are trending on social media, not because these are actually great questions I would personally ask when...
--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)

May 6, 2025 at 1:49 am

#4588099
Reply To: T-SQL Parent Child

Your dbo,starui_country_mastergroup_subgroup table appears to be missing some rows compared to the example you gave, as well.
Please fix your script.
--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)

May 6, 2025 at 1:45 am

#4588098
Reply To: T-SQL Parent Child

I'm hoping that the errors in your attached script aren't going to matter... also, the code you posted above doesn't run due to all of the errors in that.
Msg...
--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)

May 6, 2025 at 12:42 am

#4588095
Reply To: Is SQL Server Feature Complete?

No... it's not "feature" complete. First, I don't know what they heck they did to it but there was a massive slowdown when 2019 came out and it's still slow...
--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)

April 28, 2025 at 12:58 am

#4584785

Viewing 15 posts - 106 through 120 (of 59,095 total)