We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.
2009-08-03 (first published: 2009-06-05)
2,503 reads
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
2008-05-12
2,214 reads
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
2011-05-30 (first published: 2008-05-05)
22,308 reads
Yes ron k and again this will scan only 1 month at the time. Unless this is exactly what you (kristin) want it to do then I would urge you to try to understand my query as it is immensly more flexible and optimized that your stored proc.
2005-05-25
You could also hunt this site for scripts that people have posted that essentially duplicate the VB Split function and return a one-column-wide table of each word in the string. Then you could select from the table where PatIndex('%[0-9]%', OneColumn) > 0 to get the numeric value.
2005-03-14
I have found myself in the position of having to fix some errors created by a recently "departed" DBA who managed our merge replication. Apparently, a replicated table on a subscribers database was missing triggers. The other DBA decided to fix by copying the triggers from another replicated database. Of course, this did not work because […]
2005-03-11
select clientid, clientname, clientcontprimaryagtind from tclients Where Not Exists ( Select * From tclientcontacts Where clientcontclientid = clientid And clientcontprimaryagtind = 'Y' )
2005-02-14
Just in case anyone still cares about this problem, it turned out to be a conflict with the SCSI cards and the scanners (believe it or not). Once a certain volume of data had passed through the SCSI card it just seemed to close itself down until the PC was reset...We had the latest SCSI […]
2005-01-04
I have the following SP: CREATE PROCEDURE dbo.GenericWorkFlowSequence_Insert_One ( @nvcGWFSName nvarchar(50), @intGWFID int, @nvcRoleID nvarchar(256), @nvcASCU nvarchar(256) ) AS SET NOCOUNT OFF; DECLARE @intGWFSSeqNbr int SET @intGWFSSeqNbr= (select max(intGWFSSeqNbr)+100 from tblGenericWorkFlowSequence where intGWFID = @intGWFID group by intGWFID) IF @intGWFSSeqNbr = NULL BEGIN SET @intGWFSSeqNbr = 0 END INSERT INTO tblGenericWorkFlowSequence ( nvcGWFSName, intGWFSSeqnbr, intGWFID, […]
2004-12-23
As far as I know there are 2 possibilities. Either join the MS Beta tester group at http://windowsbeta.microsoft.com or if you have a MSDN subscription you can download it there. M
2004-11-08
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers