November 2007 - Posts

• Data Compression will be available in CTP-6

  Thanks to all who have contacted me for their interest in the data compression feature. Unfortunately, data compression feature is NOT available in the just released CTP-5 which is now available on the Microsoft Download Center as SQL Server 2008 Community Read More... Posted Tuesday, November 20, 2007 7:39 PM by Sunil Agarwal | 3 Comments Filed under: Data Compression

• Estimating the space savings with data compression

  Like I had indicated in my previous blog, it is recommended that you estimate compression savings on the object of interest before actually enabling compression as enabling compression is an expensive operation. To show how to estimate data compression, Read More... Posted Tuesday, November 13, 2007 12:54 AM by Sunil Agarwal | 4 Comments Filed under: Data Compression

• Types of data compression in SQL Server 2008

  SQL Server deploys two strategies to compress the data · First, it stores all fixed length data types in variable length format. If you recall, SQL Server 2005/SP2 provided a new variable length storage format decimal and numeric. Please refer to the Read More... Posted Monday, November 12, 2007 5:17 PM by Sunil Agarwal | 2 Comments Filed under: Data Compression

• Why not use compressed disk files or disk volumes?

  When we think of compressing the database, one of the first question that pops up is why not used the compressed volume? You may know that Windows OS has supported compression of individual files, folders and the entire NTFS volumes since Windows 2000. Read More... Posted Monday, November 12, 2007 4:19 AM by Sunil Agarwal | 4 Comments Filed under: Data Compression