Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 59,067 total)

Reply To: TCP Provider: A connection attempt failed for target server

The first thing to do is to see what login the stored procedure was running under and then look at the settings for the linked server connection to see 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)

October 1, 2022 at 4:29 pm

#4094382
Reply To: How Important is Software?

From the Article:
"I urge developers to have others look at what they present on the screen, and spend time learning from users, both experienced and novice. "
I've found 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)

October 1, 2022 at 4:20 pm

#4094381
Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Thanks. That's just fascinating to me because I've never seen such a thing before.
Any chance of you posting the TVF so I can try to make an experiment that duplicates...
--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)

September 30, 2022 at 5:57 pm

#4094103
Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Since you're right there and have a handy test setup, I'd be curious what happens with the same query with the comments in the following form...
SELECT SUM(results)
/* comment1 */
/* comment2...
--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)

September 30, 2022 at 2:33 pm

#4094029
Reply To: Why does antivirus stops I/O and SQL sees it as a full backup, during AV check

peter2501 wrote:
Hello,
We use Sentinel AV software. And yes, when disabled the entries for the FULL backups are gone as well.
Peter
Thanks, Peter. Lordy... that's a bit crazy. Apologies for asking and...
--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)

September 30, 2022 at 2:21 pm

#4094021
Reply To: Insert data into multiple tables after each batch of 100000 rows

I also have to ask "WHY"? Why do you need to "batch" this instead of just doing all 2 million rows, which most servers can easily handle?
And the reason why...
--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)

September 30, 2022 at 2:06 pm

#4094017
Reply To: backup practice/strategy/risks

Thanks, Jeffrey.
--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)

September 29, 2022 at 11:33 pm

#4093734
Reply To: backup practice/strategy/risks

Interesting... Just one more question, please... have you ever done a restore to test all of that (including log files)? Knowing you, I'm sure you have but I've got to...
--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)

September 29, 2022 at 11:22 pm

#4093722
Reply To: backup practice/strategy/risks

Jeffrey Williams wrote:
Daily full backups, log backups every 10 minutes.
So what's with the "Copy Only" backups? Those aren't your "Daily full backups" are they?
--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)

September 29, 2022 at 10:30 pm

#4093679
Reply To: backup practice/strategy/risks

Jeffrey Williams wrote:
To be accurate, I cannot actually run differentials in this environment either because we backup the databases from the secondary and you cannot run differentials from a copy only...
--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)

September 29, 2022 at 10:04 pm

#4093676
Reply To: backup practice/strategy/risks

@Jeffrey Williams,
How big is the largest server instance that you're doing the Daily full backups on?
--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)

September 29, 2022 at 7:11 pm

#4093580
Reply To: Why does antivirus stops I/O and SQL sees it as a full backup, during AV check

Which Anti-Virus are you using, please?
And when you disabled the AV, did the odd entries for backups disappear, as well, or are they still appearing?
--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)

September 29, 2022 at 1:33 pm

#4093423
Reply To: Partition Table by Varchar column

wrote:
Much appreciated so a phenomenal plan, your thought worked for me.
I smell spam cooking.
--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)

September 29, 2022 at 1:20 pm

#4093418
Reply To: How to get record based on nearest date in SQL

kaj wrote:
Just to play the devil's advocate here and make you think: 🙂
How do you want to handle if the date in Table A is right in the middle between...
--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)

September 28, 2022 at 9:57 pm

#4093166
Reply To: Tsql batch script does not stop

murad.ahmed wrote:
thanks all for help on the logic !
You're welcome. Were you able to fix your problem and, if so, what was the fix you employed?
--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)

September 28, 2022 at 9:46 pm

#4093165

Viewing 15 posts - 2,656 through 2,670 (of 59,067 total)