Jeff Moden

Forum Replies Created

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

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
Reply To: What Do You Want to Learn?

Only 17 responses on Steve Rezhener's thread. I'm not sure that I'd consider that to be a viable source of information considering the previous and expected attendance for these types...
--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 24, 2024 at 1:16 am

#4430933
Reply To: Add alarms to database when a query, stored procedure, SSIS package hangs

I don't believe such an alert exists. My recommendation would be to make an SQL Server Agent Job that checks for such things and schedule it to run on 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)

June 23, 2024 at 4:12 pm

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

To be honest, I've found that most such contention is because of what is appropriately referred to as "crap code". 😉
I recommend that you figure out what's beating on TempDB...
--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 23, 2024 at 4:05 pm

#4430879
Reply To: increase in database size

vsamantha35 wrote:
Post the CREATE TABLE statement for the table the index is a part of including the CREATE statements for the index(es) in quesiton. Then, post the results of 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)

June 23, 2024 at 1:13 am

#4430805
Reply To: indexes cleanup

vsamantha35 wrote:
I am attaching the index data collection file. See if you infer any useful information.
Ok then, this will be short.
The code says it ignores UNIQUE indexes. Your spreadsheet says...
--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 23, 2024 at 1:07 am

#4430804
Reply To: increase in database size

vsamantha35 wrote:
Hi All,
We have a 2 TB disk to stored of the sql database files. db has 3 data files and 1 log file. log file is stored on 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)

June 20, 2024 at 4:06 pm

#4430068

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