SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2010

Why Do My SQL 2008 Compressed Backups Shrink?


Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew.

The Facts

The database that the test was being run on was 360GB in size. The backup initially created… Read more

0 comments, 369 reads

Posted in Adventures in SQL on 25 February 2010

Why Do I Need All These Servers?


I am frequently getting requests for a new server to do this or that. Running through the usual questions to determine scope and scale, the price can get high pretty quickly. Inevitably,  talk turns to ideas on how to cut the cost while still delivering a robust platform. Typically… Read more

0 comments, 410 reads

Posted in Adventures in SQL on 23 February 2010

Stored Procedure to Sequentially Run SQL Agent Jobs


Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts, but I have a ton of them and need to get them documented. This stored procedure is used to run a series of SQL Agent jobs sequentially. It is… Read more

0 comments, 1,788 reads

Posted in Adventures in SQL on 1 February 2010