Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 59,086 total)

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
Reply To: backup practice/strategy/risks
Jeffrey Williams wrote:
Jeff Moden wrote:
My "general" recommendation for backups is...
1. Full Backup once per week.
2. Dif Backup once per day.
3. "Conditional" Log file backups every 15 to 30 minutes.
Of course, that's subject...
--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 12:38 am

#4092722
Reply To: backup practice/strategy/risks
My "general" recommendation for backups is...
1. Full Backup once per week.
2. Dif Backup once per day.
3. "Conditional" Log file backups every 15 to 30 minutes.
Of course, that's subject to change...
--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 27, 2022 at 7:34 pm

#4092621
Reply To: 2 new Column from string
biggeek2003 wrote:
I use a combo of CTE and XML to split the strings makes it super fast and easy.
```
DECLARE @DELIMITER VARCHAR(50)='|||'
;WITH CTE AS
(SELECT
S.NAME
,SOUCE=S.RAW_DATA
,XML=CAST('<M>' + REPLACE(S.RAW_DATA, @DELIMITER, '</M><M>')...
```
--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 27, 2022 at 7:29 pm

#4092620
Reply To: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

I can't wait for the 2022 Developer's Edition to come out so I can test. I normally don't bother with public test versions and won't with 2022 either. That 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 27, 2022 at 1:01 am

#4092239
Reply To: ETL from MySQL to SQL2019 using Amazon Glue

LightShip wrote:
in case anyone hits this issue down the road, I found this article very useful.
https://ruslanmv.com/blog/How-to-connect-MySQL-Server-with-AWS-Glue
Nice link. Thanks for posting 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)

September 27, 2022 at 12:40 am

#4092235
Reply To: agent job with xp_cmdshell to move files

frederico_fonseca wrote:
and using a sql agent proxy (can be per defined 1 per job) is in a way better than using the xp_cmdshell proxy (system wide).
on a multi-tenant server using...
--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 27, 2022 at 12:33 am

#4092233

Viewing 15 posts - 2,686 through 2,700 (of 59,086 total)