Jeff Moden

Forum Replies Created

Viewing 15 posts - 811 through 825 (of 59,070 total)

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

Phil Parkin wrote:
Jeff Moden wrote:
The real key here is... are people going to carry you down the hall on their shoulders if you make any changes here?
In a coffin?
A bit harsh!
Heh......
--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 4:09 pm

#4366488
Reply To: SQL Server 2012 - not accepting new connections on occasion ...

It also sounds like a possible "connection leak" in the applications that are hitting the database.
--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 4:01 pm

#4366487
Reply To: SQL to insert row with RefNum to be the next numeric number

Coung wrote:
Unfortunately, I don't have a say about the structure of the table. It's populated via an ETL process. I just want to create dummy data for testing so want...
--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:59 pm

#4366485
Reply To: List Procedure That Creates A Table

You could just search the "definition" column of sys.sql_modules for the table name with the understanding that it won't find ad hoc queries.
--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:54 pm

#4366483
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

Viewing 15 posts - 811 through 825 (of 59,070 total)