Jeff Moden

Forum Replies Created

Viewing 15 posts - 496 through 510 (of 59,069 total)

Reply To: SQL code needed for the WHERE clause..

I wouldn't use DELETE on a year old table. That'll be a lot to delete and it'll cause a "log file explosion".
I probably also wouldn't do a whole year at...
--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)

July 2, 2024 at 6:52 pm

#4433011
Reply To: The Cost of Rework

jonathan.ellison wrote:
I totally concur. Back in the late 90's and early 2000s Hoshin Principles; Greenbelt and Blackbelt training; Design-for-Six-Sigma, all stressed the importance of the "voice of the customer" and...
--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)

July 1, 2024 at 11:41 am

#4432651
Reply To: This is very concerning in a number of ways

A lot of links for that incident show up with the following search.
https://duckduckgo.com/?q=robot+suicide

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

July 1, 2024 at 3:06 am

#4432579
Reply To: Do You Have the Gifts to Be a DBA?

"Bump" to make the 2nd page of the discussion show up.
--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 29, 2024 at 4:42 am

#4432298
Reply To: A Different View of Technical Debt

The greatest technical debt I have ever experienced is when we migrated from SQL Server 2016 to 2022. That means that I'm still experiencing that "joy". Overall, "It just runs...
--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 29, 2024 at 4:36 am

#4432297
Reply To: How To Work-A-Round Not being able too use CASE within ORDER BY

YSLGuru wrote:
Jeff - I'm going with Scotts recommendation which sticks with CAST and not FORMAT. That said, just out of curiosity do you know how much data/rows need to be...
--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 29, 2024 at 4:13 am

#4432296
Reply To: How to get calculated values from a derived(?) table?

mjdemaris wrote:
Thanks Jeff, I will be sure to have some ready to use code in the future.
Heh.. "next time". You're saying that because someone already did it but... they did...
--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 28, 2024 at 9:50 pm

#4432259
Reply To: How to get calculated values from a derived(?) table?

jcelko212 32090 wrote:
You're not going to use this data as points in time, but as intervals, so model it that way
Create table events (event_number integer not null primary key, event_start_timestamp dateime2(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)

June 28, 2024 at 7:25 pm

#4432237
Reply To: Filtering Extended Events by Start Time

Grant Fritchey wrote:
Never mind. AI lied to me.
{sarcasm on}
WHAT??? AI LIED??? Surely, you jest! It's going to take over all our jobs, right? RIGHT? 😉
{sarcasm off (for the moment)}
--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 27, 2024 at 7:37 pm

#4431967
Reply To: How To Work-A-Round Not being able too use CASE within ORDER BY

If you use FORMAT anyplace where there are a lot of rows, I can only wish you luck for performance because you're going to need 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)

June 27, 2024 at 7:33 pm

#4431966
Reply To: Looking for recommendations for reporting technologies replacements

Phil Parkin wrote:
Rod at work wrote:
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No, this 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 27, 2024 at 7:31 pm

#4431965
Reply To: Looking for recommendations for reporting technologies replacements

Rod at work wrote:
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No. Absolutely not. 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)

June 27, 2024 at 7:22 pm

#4431964
Reply To: Looking for recommendations for reporting technologies replacements

Rod at work wrote:
I don't know if it would be possible to write reports using Jupyter Notebooks, that would be canned reports accepting only parameters, such as start and end dates....
--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 26, 2024 at 5:53 pm

#4431676
Reply To: should i make as many datafiles for temdb as many cpus i have

I'm confused.... the log file name of your latest graphic doesn't appear to match or relate to any database names in your first graphic. You've also not said anything about...
--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 25, 2024 at 10:12 pm

#4431472
Reply To: How to get calculated values from a derived(?) table?

Please see the article at the first link in my signature line below. Most of us like to test our answers before we publish them. For that, we need "Readily...
--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 25, 2024 at 4:30 am

#4431226

Viewing 15 posts - 496 through 510 (of 59,069 total)