Jeff Moden

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 59,067 total)

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
Reply To: Just a rant about the SQL Server 2022 upgrade

cphite wrote:
How in the heck does something like this get past QA?
From what I've seen over the years with SPs, CUs, and new releases, I'm starting to thing 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)

April 24, 2025 at 9:20 pm

#4583750
Reply To: Size of DB on physical disk doesn't match Disk Usage by Table report

The "Used but Unallocated Space" is usually because of a "wonderful" feature known as "Fast Inserts". It is meant to provide a performance gain when doing inserts containing a huge...
--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 24, 2025 at 9:18 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
If you look at the code I posted, the text to describe what happens says that "When the fractional precision of the datetime2(n) value is greater than three...
--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 23, 2025 at 5:48 pm

#4583127

Viewing 15 posts - 76 through 90 (of 59,067 total)