Jeff Moden

Forum Replies Created

Viewing 15 posts - 616 through 630 (of 59,063 total)

Reply To: Time and Space: How to Monitor Drive Space in SQL Server
Perry Whittle wrote:
Jeff Moden wrote:
Sam Catchesides wrote:
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple...
- This reply was modified 2 years, 1 months ago by Jeff Moden.
--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, 2024 at 1:20 am

#4414303
Reply To: Time and Space: How to Monitor Drive Space in SQL Server

Sam Catchesides wrote:
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS report...
--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 21, 2024 at 9:58 pm

#4413836
Reply To: Hardcoded filter vs filter by parameter

This is very likely a case where the use of a statement level OPTION (RECOMPILE) will work perfectly and very quickly.

--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 21, 2024 at 3:30 pm

#4413767
Reply To: Do I need a recursive query for this? bill of materials (sort of)

Heh... you, of all people, should know about "double posting".
Folks, no answers here, please. Instead, go to the duplicate post and post there. Thanks.
https://www.sqlservercentral.com/forums/topic/do-i-need-a-recursive-query-for-this-bill-of-materials-sort-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)

April 19, 2024 at 3:25 am

#4412991
Reply To: Do I need a recursive query for this? bill of materials (sort of)

I'd have to see more but I'd start with the idea that the "Starter" is actually a "Product" and that product becomes an "Ingredient" as if you bought it from...
--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 19, 2024 at 3:23 am

#4412990
Reply To: Query run from SQL agent, not returning same results as from query window
Phil Parkin wrote:
I would use the following code to get 'last' Sunday. Seems a bit simpler than the current version.
```
SELECT DATEADD (wk, DATEDIFF (wk, 0, GETDATE ()), 0)...
```
--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 15, 2024 at 2:01 pm

#4411466
Reply To: Query run from SQL agent, not returning same results as from query window

Do not use DATEDIFF(WK) if you need for the first of the week to be based on any day of the week other than SUNDAY. It is ALWAYS based on...
--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 15, 2024 at 1:38 pm

#4411462
Reply To: The First Rule

Steve Jones - SSC Editor wrote:
That might be your network or connection. The links work for me.
https://seths.blog/2019/04/the-first-database-rule/
Might be me, indeed. I'm running some pretty secure connections. If the connection doesn't prove themselves 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)

April 13, 2024 at 1:56 am

#4410727
Reply To: The First Rule

And then there's the change in security or the deletion of a full site with no record but a trail of now broken links...
Secure Connection Failed
An error occurred during 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)

April 12, 2024 at 9:18 pm

#4410676
Reply To: The Code Freeze

Steve Jones - SSC Editor wrote:
David.Poole wrote:
I think your point about humans needing a change of pace rings true.
I know it sounds daft but I used to enjoy the excitement that surrounded a major...
--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 11, 2024 at 7:07 pm

#4410254
Reply To: Selecting MAX value in 1 column based on code in another column?

tsobiech wrote:
Jonathan AC Roberts wrote:
I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure 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)

April 11, 2024 at 6:30 pm

#4410239
Reply To: Query performance analysis

as_1234 wrote:
I've discovered that the table is updated overnight and the issue re-occurs overnight.
If I run the code in the morning then it takes too long to complete. If I...
--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 9, 2024 at 12:54 pm

#4409218
Reply To: Create list of random, mutually exclusive selection(s) from the same table

Steve Collins wrote:
Excellent query Jeff. Thank you, thank you! Multiplying by 'combo' within the TOP clause is very nice
Thanks for the feedback, Steve. The hard part was to make "Combo" available...
--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 9, 2024 at 12:08 pm

#4409192
Reply To: Designing two tables considering following scenario.

You working code link leads to a "Run this fiddle" link. I cancelled from 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)

April 9, 2024 at 12:06 pm

#4409190
Reply To: Tunning or alternative to PIVOT

Since you posted a graphic of the execution plan instead of an actual execution plan and you post no meta-data for the table and you posted no code, we're going...
--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 9, 2024 at 11:55 am

#4409176

Viewing 15 posts - 616 through 630 (of 59,063 total)