Jeff Moden

Forum Replies Created

Viewing 15 posts - 721 through 735 (of 59,070 total)

Reply To: Best Practice for full backup and transaction log truncation

Taking full backups does not backup the logfile over time. If you're in the SIMPLE recovery model, then the log file will be self truncating whether you take full backups...
--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)

February 24, 2024 at 4:57 am

#4383908
Reply To: Best Practice for full backup and transaction log truncation
Post withdrawn because I don't actually know much specifically about VEEAM and didn't want to provide any misleading info.
- This reply was modified 2 years, 4 months ago by Jeff Moden.
--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)
February 23, 2024 at 9:20 pm

#4383765
Reply To: Best Practice for full backup and transaction log truncation

The only correct answer is "It Depends". I recommend that you lookup what the abbreviations RPO and RTO are for starters. Also, find and read up on the Full, Differential,...
--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)

February 23, 2024 at 9:08 pm

#4383762
Reply To: Downside to running a query in parallel

water490 wrote:
I am a SS rookie. To me it seems like running a query in parallel whenever possible is a great idea b/c that way more work can 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)

February 23, 2024 at 8:58 pm

#4383749
Reply To: How to suppress the info of queries execution in Stored Procedure.

rkordonsky 63916 wrote:
I had to create a Cursor to update the data in the table.
It would be interesting to know more about that. Usually, it's a serious mistake that can 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)

February 23, 2024 at 1:48 am

#4383256
Reply To: How to get Active counts between dates. Please

This reminds me of the good ol' days on these forums... thanks for the memories, folks.
--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)

February 20, 2024 at 8:42 pm

#4381900
Reply To: How to get Active counts between dates. Please
Jonathan AC Roberts wrote:
If you install this DateRange function, this gives certainly the shortest SQL if not the fastest
```
select CONVERT(date, d.value) Date, 
   ...
```
--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)
February 20, 2024 at 1:58 pm

#4381710
Reply To: How to get Active counts between dates. Please

IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind any missing...
--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)

February 20, 2024 at 5:02 am

#4381479
Reply To: xp_cmdshell giving error error browsing Sharepoint Online directory files

Mr. Brian Gale wrote:
My opinion though - SQL Server and xp_cmdshell is an odd tool to use for downloading files from sharepoint... Powershell is a much better way to do it in...
--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)

February 20, 2024 at 3:16 am

#4381435
Reply To: Don't report error when one Maintenence Plan Task fails

Tony wrote:
I have a Job running a Maintenence Plan. The plan performs the Backup Database, Check database Integrity, Maintenence Cleanup and Reorganise Index tasks. Occasionally the Reorganise Index task fails...
--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)

February 20, 2024 at 3:06 am

#4381434
Reply To: SQL Backup Strategy Solution

Mary wrote:
Between the time that Rubrik starts its snapshot and ends it snapshot, tlog files are deleted.
I don't use Rubrik but any decent tool will turn off the "A" (archive)...
--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)

February 20, 2024 at 2:40 am

#4381423
Reply To: throttle things so that use of certain linked servers get less resources

frederico_fonseca wrote:
the best way is to use openquery (use dynamic SQL if required to pass filtering parameters) and convert all numbers and dates to strings on source - if required...
--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)

February 20, 2024 at 2:33 am

#4381421
Reply To: Who else is Actual competitor of SQL Server when it comes handling Complexity?

IMHO, the only "actual competitor" is ... the people writing the code.
If they not so good at SQL Server, the code is going to be slow. What makes you think...
--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)

February 20, 2024 at 1:50 am

#4381403
Reply To: Downgrade a DB from 2022 to 2019

Just to ask the question, have you tried running the database in the 2019 Comparability Level to see if that fixes the issue?
--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)

February 20, 2024 at 1:03 am

#4381391
Reply To: How to find the root cause for log .ldf file increased suddenly to 500 gb

Like I said 😉 ...
Jeff Moden wrote:
You could/should setup an Extended Event to capture anything (including code) that makes the log file grow. Of course, you'd have to shrink the log...
--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)

February 18, 2024 at 5:22 pm

#4380712

Viewing 15 posts - 721 through 735 (of 59,070 total)