POST YOUR TOPICS HERE

Hi friends, This blog welcomes you all to post you own new tricks and tips here. For this you have to just send a mail to sendmytricks@ymail.com

Your post would be posted along with your name and location. For this you have to send a mail to the above mentioned id.

Format for sending mail.

Subject : MY TRICKS

1. Your name [will be displayed if display name not given]
2. Display name [This name would be displayed along with you post]
3. You location [For ex., Chennai, India.]
4. Post topic.
5. Details.

Pictures are also allowed. For that you need to send the pictures as links.

IMPORTANT NOTE : Please do not spam in this mail id. You can send you ideas/problems in this mail id itself.

Wednesday, March 5, 2008

Basic process in compression - SQL Server 2008

-> 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.
Posted by at No comments:

Backup Compression - SQL Server 2008

In 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.
Posted by at No comments:
Subscribe to: Posts (Atom)