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:

Post a Comment

Subscribe to: Post Comments (Atom)