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....
Here it is, next installment of SQL 2008 CTP which is July CTP of SQL Server 2008 is now available for download on the SQL Connect site (you need to have a passport login to download). There are few enhancements to the Reporting services, introduction of new date & time data types including the performance...
SQL 2008 books online confirms the deprecated features that are not supported with the release of RTM, those few lists are as follows: SP_DBCMPTLEVEL is replaced with ALTER DATABASE .. SET COMPATIBILITY_LEVEL SP_HELPDEVICES is replaced with sys.backup_devices system table SP_RENAMEDB is replaced with...