Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,701 through 2,715 (of 59,091 total)

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
Reply To: When use sql graph on sql server 2019 ?

Heh... I don't "node" for sure but I'm sure that it'll be an "edge" case. 😀 Get the "net" out... we'll all go "wandering" when it happens. 😀

--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 26, 2022 at 8:18 pm

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

That's some pretty awesome feedback, Steve. Glad all of it worked out and thanks for posting what you did. Glad the splitter and the modifications you made worked as well...
--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 26, 2022 at 8:12 pm

#4092173
Reply To: how to change hard coded dates to ytd please

Not that it matters now but the parsing error is due to a parentheses after P.TranDate in the WHERE of the outer query. The two WHERE clauses are ok because...
--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 25, 2022 at 5:02 pm

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

Jeffrey Williams wrote:
Nothing wrong with using xp_cmdshell - except security. And no, I don't mean running xp_cmdshell safely - I mean the context of the user running it. Since this is...
--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 25, 2022 at 4:25 pm

#4091759
Reply To: Best Approach to move the databases in Always On

I Googled the title of your post... you should try it. 😉
We don't use AG at work and so I've not actually used it. If I were put on 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)

September 25, 2022 at 2:04 am

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

Jeffrey Williams wrote:
As I stated on the other forum - why not use the appropriate subsystem in SQL Server Agent to run the commands directly? Why is it necessary to use...
--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 24, 2022 at 6:56 pm

#4091600
Reply To: Are You a Traffic Cop?

Since this article has recently been posted again, let's review the title...
Are You a Traffic Cop?
No. I'm a "Beneficial Dictator". 😀
--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 24, 2022 at 12:16 am

#4091396

Reply To: agent job with xp_cmdshell to move files

lan2022nguyen wrote:

i have the following t-sql to move files from 1 directory to another.

I tried both versions. job step succeeded with no errors, but files do not move.

any thoughts/suggestions?

--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 24, 2022 at 12:00 am

#4091395

Reply To: Query memory grant

sqlguru wrote:

Thanks. I agree with you. But this is read only copy used for reporting. We are looking for other ways to improve performance by adding more memory but also...

--Jeff Moden

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 23, 2022 at 8:53 pm

#4091361

Reply To: Query memory grant

sqlguru wrote:

We have reporting server and thinking of limiting the max percentage granted to each query. So it will use less memory than desired. I know there are some cons...

--Jeff Moden

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 23, 2022 at 6:31 pm

#4091316

Viewing 15 posts - 2,701 through 2,715 (of 59,091 total)