Posted by Mr Darani Vasan |
|
Filed under : Kioskea - Tribune >> Office Software >> Informatics >> Backup Compression - SQL Server 2008 Key words : latest sql,sql 2008,sql,sql server,sql server 2008,Backup Compression - SQL Server 20087 Mar, 2008 01:51 pm | |
 | |
Enlarge text
Reduce text size
Add to Facebook
Add to Yahoo ! MyWeb
Add to Furl
Add to Del.icio.us
Add to Digg
Add to Google Bookmarks
Add to NewsvineIn the SQL Server 2005 version, compression was available via third party backup softwares like 1. SQL LiteSpeed 2. SQL Unzip SQL Server 2008 has an inbuilt compression for backups.
-> Assume you have a column of data on a single page of rows that contain values like
1. Run
2. Running
3. Runner
4. Runoff
5. Runover
-> There's quite a bit of redundant data 'prefixing‘ each of the rows in this column.
-> Prefix value of ‘Run' as 1 and each column ending up with pointers to that prefix value - resulting in values like 1, 1ning, 1ner, 1off, 1over.
-> The prefix value 1’s definition is stored in the CI structure.
-> By this compression process 30%(approx) of the space is saved when compared with storing the original data as such.
Article originally published on: Tweeks
|
