Jeff Moden

Forum Replies Created

Viewing 15 posts - 841 through 855 (of 59,091 total)

Reply To: DB with MDF and multiple NDFs vs a single large MDF - all on same Logical Drive.

The real key here is... are people going to carry you down the hall on their shoulders if you make any changes here? If not, I'd leave it all 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)

January 23, 2024 at 3:20 pm

#4366453
Reply To: Does INSERT's affect performance depending on INSERT order?

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Well you can test that too.
My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind 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)

January 22, 2024 at 4:57 am

#4365570
Reply To: Learning NoSQL

You missed my point... and that's actually OK. I wasn't suggesting one of the other... I was pointing out that a whole lot of other people do and it's usually...
--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)

January 22, 2024 at 4:52 am

#4365569
Reply To: Does INSERT's affect performance depending on INSERT order?

Jonathan AC Roberts wrote:
Well you can test that too.
My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of testing needs to be done.
--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)

January 20, 2024 at 5:42 pm

#4365023
Reply To: Database mail quit working

Interesting... thanks, Glenn.
--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)

January 20, 2024 at 5:37 pm

#4365019
Reply To: Does INSERT's affect performance depending on INSERT order?

Be careful when testing. In this case, the OP hasn't defined what he means by "Assume I'm going to insert lots of data". Does that mean for just one, multi-row...
--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)

January 20, 2024 at 3:17 pm

#4364971
Reply To: Does INSERT's affect performance depending on INSERT order?

oRBIT wrote:
Assume I have a table with a clustered datetime-index. Assume I'm going to insert lots of data. The data to be inserted is not in any specific order. Would...
--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)

January 19, 2024 at 3:18 pm

#4364484
Reply To: How to write a script that kills a process if it's blocking over 1 minute

This isn't the right way to do things. You can easily get to the point of where your system is doing nothing but rollbacks. You could also be causing grave...
--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)

January 19, 2024 at 2:58 pm

#4364476
Reply To: Leveraging AI Tools for SQL Queries

David.Poole wrote:
I'm uncomfortable with ChatGPT. I've found that a lot of its answers are believable rather than correct.
Exactly. I summarize that as being "Confidently Incorrect" and, in that area, ChatGPT...
--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)

January 19, 2024 at 1:19 pm

#4364412
Reply To: Leveraging AI Tools for SQL Queries

@jonathan-2,
While the AI is quite capable of explaining exactly WHAT the code does programmatically, it's simply not capable of figuring out the WHY for most code. For example, the AI...
--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)

January 19, 2024 at 1:15 pm

#4364411
Reply To: Top of Your Profession
David.Poole wrote:
From what I have seen the people I would regard as being at the top of their profession have certain traits.
- Competence with confidence
- Natural teachers. If feels like...
--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)
January 19, 2024 at 1:00 pm

#4364404
Reply To: Leveraging AI Tools for SQL Queries

Not aimed at the author but aimed at the whole concept... Let's look at the first example prompt in the article...
You are an SQL Server database developer. Assume 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)

January 19, 2024 at 5:01 am

#4364215
Reply To: Learning NoSQL

Heh... let's look at the first paragraph in the article...
It's a good idea to learn more about different technologies. I've been amazed throughout my career, and even now as...
--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)

January 18, 2024 at 5:46 am

#4363657
Reply To: Index performance: Can Mix of lower and upper case cause issues?

Not enough info... we're just guessing from descriptions. Please see the article at the 2nd link in my signature line below for what to post for these types of performance...
--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)

January 18, 2024 at 5:30 am

#4363649
Reply To: How to extract number that is greater than or equal to 16 digits
Possible solution to the original question...
Given the original example data...
```
Create Table #Payments (ID int, Comment Text)

INSERT INTO #payments values (1, '65607 Processed via? DISC Last 4 digits...
```
--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)
January 18, 2024 at 4:51 am

#4363625

Viewing 15 posts - 841 through 855 (of 59,091 total)