Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and reduce the storage requirements for your data. SQL Server 2008 provides significant performance improvements for large I/O bound workloads such as data warehousing. Not only the data compression even SQL development team are looking to input native...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/sql2008/archive/2007/10/03/2325.aspx