Jeff Moden

Forum Replies Created

Viewing 15 posts - 376 through 390 (of 59,069 total)

Reply To: Help with index rebuild

I might get a few eye-rolls from you, in return, because I'm going to tell you to stop doing generic, catch-all, supposed "Best Practice" index maintenance. It's all causing more...
--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 30, 2024 at 10:03 pm

#4463930
Reply To: Daily maintenance plan causing performance problems

Vernon Jimmerson-306463 wrote:
I do mean to be of good spirit so please don't take offense.
You've certainly impressed us there.
--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 29, 2024 at 8:23 pm

#4463585
Reply To: Unstuck

Speaking of "stuck"... rumor has it that the good folks at SSC are going to start working on problems like the one I'm getting ready to experience when I hit...
--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 29, 2024 at 3:37 pm

#4463549
Reply To: Unstuck

Rod at work wrote:
Jeff, no, I don't have access to the TFS VM's disk to see allocated vs. used disk space.
Bummer. And, yeah... them not "getting it" after all the issues 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 29, 2024 at 3:34 pm

#4463547
Reply To: Unstuck

Rod at work wrote:
To this day I don't understand how come no one in IT saw the pattern that adding only a little more disk space and having that consumed within 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)

September 29, 2024 at 2:46 pm

#4463529
Reply To: Check sequential order of status of items

Phil Parkin wrote:
Ah yes, there's another thing I should have mentioned! After composing your code, please try running it. Yours fails to run.
The code probably worked perfectly on the OPs machine. ...
--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 29, 2024 at 2:36 pm

#4463527
Reply To: Forum Etiquette: How to post data/code on a forum to get the best help

brian.cook wrote:
This was very helpful. I learned some also from it.
I hopefully have posted my current question in a better format and have explained myself well enough.
Thank you
My apologies. Apparently,...
--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 29, 2024 at 1:56 pm

#4463517
Reply To: Weekday different executing procedure directly or executing by SQL Server Agent

If you would post the code you're using, perhaps we could solve all of your problems with a bit of a magic temporal formula that doesn't rely on any settings...
--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 27, 2024 at 3:26 am

#4462901
Reply To: Pivot Mistake

antonio.perez wrote:
Thanks a lot Drew.
It works perfectly
I think you may have a larger issue on your hands... It's a really bad idea to store temporal data as strings.

--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 27, 2024 at 2:31 am

#4462893
Reply To: SQLExternalMonitoring what is it in sp_who2 result

You'll probably need to look at Task Manager or Resource Monitor to figure out exactly what software is being executed there. Do you have an infrastructure team that might know?

--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 27, 2024 at 2:25 am

#4462892
Reply To: When Do We Worry About Scalability?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
A million likes on that reply, Steve.
Thanks. I learned this at Redgate, where we had like 5 web frameworks at one point and realized that it took weeks...
--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 21, 2024 at 5:27 pm

#4461131
Reply To: I have never seen an insert statement with -= tablename in place of values

Jonathan AC Roberts wrote:
I think it is a typo, they probably meant to type '-- = inv.tblSoftware'
Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the insert...
--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 21, 2024 at 5:09 pm

#4461130
Reply To: Automate reports for when the SQL database was last used

First, I hope that you're taking a final full backup followed by a "Tail Log" backup to properly shut down a database prior to drop it.
As for determining if 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 21, 2024 at 4:40 pm

#4461124
Reply To: TSQL query - adapt Part2 to include Part1

Ed B wrote:
I don't understand what you need to do. I presume that you don't want to union all query 1 with query 2. Do you need to left outer join...
--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 21, 2024 at 12:55 pm

#4461097
Reply To: I have never seen an insert statement with -= tablename in place of values

lee.hopkins wrote:
We have a third part software and looking at some of their SQL we found this
INSERT INTO tblSoftware ( Inventory , Software, [Name] , Manufacturer , [Language] , [...
--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 21, 2024 at 12:24 pm

#4461087

Viewing 15 posts - 376 through 390 (of 59,069 total)