Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 59,086 total)

Reply To: How to summarise values in hierarchies

Thanks for the feedback, BOR15K.
--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 14, 2022 at 6:39 pm

#4112858
Reply To: The VALUES Limit

Jason A. Long wrote:
Just keep in mid that, "just because you can, doesn't mean you should"... Super long value lists can really eat up compile memory and compile time.
Oh, I get that. ...
--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 14, 2022 at 6:32 pm

#4112853
Reply To: The VALUES Limit

This ol' man learned something new today thanks to the replies above. Thanks, folks. Special thanks to Jason Long for posting demonstrative code to drive the point home.
So the correct...
--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 14, 2022 at 3:59 pm

#4112775
Reply To: master data files location for AWS EC2 EBS disks

But that doesn't have anything to do with how many drives you have or whether or not you mix MDFs with LDFs. It only has to do with the speed...
--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 14, 2022 at 1:54 am

#4112491
Reply To: The VALUES Limit

frederico_fonseca wrote:
answer is not always correct on this case.
Interesting... When and how is it incorrect... in any case?
--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 14, 2022 at 1:46 am

#4112488
Reply To: Refinement of my query in a best way with optimum results (for large data)

mehmood wrote:
REPLACE(), & LOWER() are being used for matching in all cases.
You asked for help with performance... those are performance issues that need to be fixed... "in all cases" when...
--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 14, 2022 at 1:21 am

#4112479
Reply To: SQL Scheduled Job Performance
Here's what you asked for, along with a last run status...
```
   WITH
cteJob AS
(--==== Get only the jobs that are enabled
 SELECT job_id ,name
  ...
```
--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 14, 2022 at 1:13 am

#4112477
Reply To: Error: Cannot insert duplicate key row in... a non-unique index?!

I still cannot fathom the idea of or the need for updating the PK.
--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 13, 2022 at 9:41 pm

#4112446
Reply To: Questions about Fact Table structure

Why would people working with commodities only be interested in only the "end of each month + 2 days"? And if you're doing it to condense the data for yearly...
--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 13, 2022 at 9:25 pm

#4112440
Reply To: master data files location for AWS EC2 EBS disks

With the understanding that I'm NOT an AWS EC2 ninja by any means, I cannot imagine doing anything different for drives (by letter) on EC2 than you would for your...
--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 13, 2022 at 8:39 pm

#4112430
Reply To: How to compare average prices of weekday vs weekend

I saw a "67" as an average and thought that was incorrect and that caused me to take the post down until I could double check. It's actually correct. Here's...
--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 13, 2022 at 8:29 pm

#4112429
Reply To: How to compare average prices of weekday vs weekend
Sorry... something went wrong and so I took the post down. I'll be back.
- This reply was modified 3 years, 9 months ago by Jeff Moden. Reason: Fixed output and code. Had the Weekdays and Weekends reversed
- This reply was modified 3 years, 9 months ago by Jeff Moden. Reason: Error in post. Took the post down until I can fix 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)
November 13, 2022 at 5:46 pm

#4112386
Reply To: How to compare average prices of weekday vs weekend

phonecase wrote:
Hello,
I have a task where I need to find the task of a rental price where the rental price is different when it's a weekday vs the price when...
--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 13, 2022 at 4:16 pm

#4112365
Reply To: How to compare average prices of weekday vs weekend

Eirikur Eiriksson wrote:
Here is a suggestion that should get you passed this hurdle
Definitely a thumbs up for NOT using the awful DW datepart. Long live DateSerial# ZERO! 😀
--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 13, 2022 at 4:02 pm

#4112364
Reply To: Display values from ntext defined field

If you would post more detailed information (like you've been asked before), it 1) wouldn't take so long and 2) people wouldn't give up on you.
I'll point you to 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)

November 13, 2022 at 12:42 am

#4112185

Viewing 15 posts - 2,491 through 2,505 (of 59,086 total)