Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 59,098 total)

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, 10 months ago by Jeff Moden. Reason: Fixed output and code. Had the Weekdays and Weekends reversed
- This reply was modified 3 years, 10 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
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above

That sounds good and right, Jonathan. I tell people that good splitters shouldn't make any assumptions and that it should return EVERYTHING that's between the delimiters, an empty string if...
--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:36 am

#4112184
Reply To: Are the posted questions getting worse?

@Webmaster finally responded. It turns out that Steve Jones is no longer the "watcher" there. I got a hold of Steve through his email and he said they'd notify 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:32 am

#4112183
Reply To: Email notifications not working

Actually, they stopped working on or about Oct 26th and, yes... they're still broken.
I did finally get an acknowledgement for @WebMaster on this site (Steve is no longer the watcher...
--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:23 am

#4112178

Viewing 15 posts - 2,506 through 2,520 (of 59,098 total)