Jeff Moden

Forum Replies Created

Viewing 15 posts - 916 through 930 (of 59,091 total)

Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?

CreateIndexNonclustered wrote:
Does the 6% performance reduction pose a real operational problem at the system level?
At the micro scale, small performance reductions may not matter to the individual process incurring it,...
--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)

December 5, 2023 at 11:31 pm

#4340470
Reply To: Small Transactional Table with Frequent Updates

This appears to be a classic "Next_ID" table and I find it difficult to understand why anyone would be using such a thing in this day and age, especially 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)

December 5, 2023 at 12:38 am

#4339819
Reply To: txt file Pipe

juliava wrote:
i used this code:
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM dbo.CustomerInformation " queryout C:\Data\Objects.txt -t"|" -c -T ' and it is not working
What is your definition of "Not Working" here?
--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)

December 5, 2023 at 12:11 am

#4339816
Reply To: Migrating DB to new DB schema

frederico_fonseca wrote:
Jeff Moden wrote:
Phil Parkin wrote:
Jeff Moden wrote:
Apparently I WAS WRONG.
I'm framing this! 🙂
🙂
very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!
Heh... and freely admitted it....
--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)

December 4, 2023 at 11:41 pm

#4339807
Reply To: Average price calculation

Puiu wrote:
I have learned something, so I hope that I will do better in the future.
Awesome. Thanks for the feedback.
--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)

December 4, 2023 at 11:39 pm

#4339806
Reply To: Average price calculation

Puiu wrote:
yes, I made a mistake when I copied the value. It's exactly what I need, thank you!
The next question is, do you now understand how to do such a...
--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)

December 4, 2023 at 6:23 pm

#4339658
Reply To: Sporadic error during restore job

It has nothing to do with xp_CmdShell. There's something wrong with the RESTORE command or the file wasn't found by the xp_CmdShell command.
If it were me, I'd modify the job...
--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)

December 4, 2023 at 3:03 pm

#4339567
Reply To: GitHub Copilot - Our Best Ally for T-SQL

Post removed.
--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)

December 4, 2023 at 2:22 pm

#4339520
Reply To: Migrating DB to new DB schema

Phil Parkin wrote:
Jeff Moden wrote:
Apparently I WAS WRONG.
I'm framing this! 🙂
🙂
--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)

December 4, 2023 at 2:18 pm

#4339519
Reply To: Need help on query - DATEDIFF

Not sure how long you're planning to have this code active but it will "only" continue to work if the dates are less than 68 years, 1 month, 2o days,...
--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)

December 4, 2023 at 2:06 am

#4339220
Reply To: Migrating DB to new DB schema

I could certainly be wrong ~~but I'm not sure this can be done. I don't remember where I read it (mostly because I don't use containers, or at least not...~~
--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)

December 4, 2023 at 1:35 am

#4339218
Reply To: GitHub Copilot - Our Best Ally for T-SQL

Nice and complete article, Daniel. I, unfortunately, don't have the time to give it a try myself... at least now right now.
What WOULD be interesting is to give it 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)

December 4, 2023 at 1:23 am

#4339213
Reply To: SQL Server Windows NT - 64 bit" in Task Manager: CPU high

Grant Fritchey wrote:
I'm confused. What is this in relation to?
Typical "prelude to SPAM under another name or tag team".
--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)

December 3, 2023 at 1:50 am

#4338770
Reply To: An Incomplete Window Definition

As a bit of a sidebar, the default sucks for performance. ROWS is faster than RANGE in the testing I've done in the past. It would have been nice if...
--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)

November 30, 2023 at 4:10 pm

#4337425
Reply To: Logging SQLExceptions

Grant Fritchey wrote:
Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:
--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)

November 30, 2023 at 3:38 pm

#4337394

Viewing 15 posts - 916 through 930 (of 59,091 total)