Data Compression in Microsoft SQL Server 2008

Play Data Compression in Microsoft SQL Server 2008
Sign in to queue

Description

Is your database big? Are you interested in reducing its size to half or even to one-third? The new release of SQL Server will provide you native data compression for your tables, indexes, and partitions that can significantly reduce the size of your database. A smaller database can lead to better performance for IO bound loads, reduce memory requirement and the manageability cost (e.g., backup/recovery) of your database. This session describes how SQL Server compresses the data in SQL Server and its impact on the workload. We also share the best practices and the lessons learned based on the feedback from early adopters.

Day:

0

Code:

08_NA_DAT3

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents