However, one customer, ServiceU, estimated it would save between $25-$50K in its first year using SQL Server 2008 Data Compression. Now, that news will even make Ebeneezer Scrooge happy.

Now, just a simple BACKUP DATABASE statement will use compression. To run a backup without compression when it's the server default, simply use the WITH NO COMPRESSION option. SQL Server 2008 finally ...

SQL Server’s first attempt at Data Compression actually looks pretty good. As I noted in my beta preview (see “Microsoft’s ‘Katmai’ is filled to the brim”), SQL Server 2008 provides ...

The best SQL Server release to date, it sports more nice new features than you can count, and the improvements extend to both performance and manageability. Whether you manage an OLTP environment ...

If you go this route, you won't have to change a thing about your backup scripts in order to take advantage of compression. Now, just a simple BACKUP DATABASE statement will use compression. To run a ...

Database margin compression, helped by open source Written by Dana Blankenhorn, Inactive July 20, 2006 at 4:00 a.m. PT I had a very nice chat late yesterday with Josh Berkus , who works as the Sun ...

Data Compression: The process of encoding information using fewer bits than the original representation, thereby reducing storage requirements. Query Processing: ...