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...

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>')...

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...

Nice link.  Thanks for posting it.

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...

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. 😀

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...

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...

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...

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...

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...

Since this article has recently been posted again, let's review the title...

Are You a Traffic Cop?

No.  I'm a "Beneficial Dictator". 😀

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?

            
September 24, 2022 at 12:00 am
            
#4091395

            
            
                                                
        

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...

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...