Viewing 15 posts - 1 through 15 (of 6,207 total)
We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and how do...
August 12, 2022 at 8:30 pm
I selected what was provided as the 'correct' answer - but I disagree that is the correct answer. For a system dealing with multiple time zones - you actually want...
August 12, 2022 at 7:36 pm
You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders. Is that correct?
My next...
August 12, 2022 at 4:30 pm
What is meant by Cleanup the transaction log after removing the db from AG?
This means removing the database from the AG, and shrinking the log by whatever means necessary,...
August 11, 2022 at 5:57 pm
FWIW - I backup a 6TB+ database every night in less than 2 hours. That process backs up to a local drive - then copies the file...
August 10, 2022 at 7:47 pm
I would recommend using Robocopy - it can be called from a PS script and there are many possible parameters to fit almost any requirement.
The output from Robocopy also provides...
August 10, 2022 at 6:20 pm
A couple more points:
August 10, 2022 at 6:15 pm
SQL Server cannot truncate the log until after the backup completes - because that is the last phase of the backup process. Once the database has been backed up, SQL...
August 10, 2022 at 5:57 pm
The recommendation is to not have more than 8 tempdb files - unless you are specifically seeing contention. You can start here: https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention
August 10, 2022 at 5:42 pm
I see a further problem - the files obviously have timestamps associated with the file. Processing them in 'any order' could be problematic if there could be actions/updates for the...
August 8, 2022 at 10:32 pm
You don't really need SSMS to be able to get a copy of that package - it depends on how it was deployed. For 2008 deployments you could deploy to...
August 8, 2022 at 10:20 pm
To the specific question - yes, setting a commit size and batch size will reduce the impact on the transaction log and allow the log to be truncated. Whether or...
August 7, 2022 at 5:11 pm
Here is something that rubs me on a daily basis:
I hate sprinkling my code with RAISERROR just for the sake of printing status messages, because it's ugly and confusing...
August 5, 2022 at 8:26 pm
Along the same lines, what techniques do people use to inject commas into, say, @@ROWCOUNT vs the FORMAT statement - FORMAT( @@ROWCOUNT ), '###,###,###,##0' ) AS RowCount
I still find...
August 5, 2022 at 8:15 pm
You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders. Is that correct?
My next question would...
August 5, 2022 at 7:20 pm
Viewing 15 posts - 1 through 15 (of 6,207 total)