The name given to the process of encoding data such that it uses lesser number of bits as compared to the original representation.
9
votes
2answers
235 views
Is data retrieved from SQL Server compressed for transmission?
Is data retrieved from Microsoft SQL Server compressed? If this is controlled by the connection string, is there any simple way to tell if any particular app is using it?
I'm examining analysis ...
7
votes
2answers
257 views
PAGE compression in SQL Server effect on running queries
I am planning to apply PAGE compression to some of the big tables in my database (DW to be precise). These tables are fairly big with over 15 Billion rows. When I applied the compression in test ...
5
votes
1answer
298 views
How does table compression affect SQL Server's buffer pool?
I'm curious as to how SQL Server's buffer pool is affected by compressed data tables.
Is the data in memory compressed, just as it is on disk, or is it fully decompressed?
If the data is stored ...
4
votes
1answer
225 views
SQL 2008 Merge Replication and table-level data compression
What would happen if you enable data compression (either row or page-level) on a replicated table (merge replication) where the publisher is SQL 2008 Enterprise (Supports data compression) and the ...
3
votes
1answer
73 views
Compressions vs shrinking a database
Is compression and shrinking a database in SQL Server same? If I compress a table, will it decrease query performance and DML?
3
votes
2answers
143 views
SQL database backups methods-tools-procedures
Currently, I am investigating some way to more efficiently backup 4 Production SQL Databases (3 different servers/instances) and would like to know if anyone else has had the problems we are having ...
3
votes
0answers
99 views
Is SQL Server data compression categorically good for read-only databases?
Some literature on SQL Server data compression I read state that the write cost increases to about four times what would normally be required. It also seems to imply that this is the primary downside ...
2
votes
2answers
334 views
Does adding page compression to a table also compress existing indexes?
I am creating a series of new tables that will have page level compression enabled.
Will this affect the indexes as well, or will I have to also specify compression when creating the indexes?
create ...
2
votes
3answers
1k views
Backup Compression in SQL Server 2005
I noticed that simply zipping my backup files reduces the space used by 70%
My idea was to, initially, backup the databases to a local server; then, using Bacula or Cobian (I don't have a budget), ...
2
votes
1answer
157 views
Why 2 allocation units during online index rebuild to different file group?
I'm in the process of rebuilding the clustered index of a big table to a different file group. I'm monitoring the rebuild process using sys.system_internals_allocation_units. I'm 3h in but not done ...
2
votes
1answer
199 views
myisampack running really slow for large DBs
I was going through compressing a bunch of archival myisam tables using myisampack
It was making decent progress until it got to the most recent tables. The overall database is a set of archives for ...
1
vote
1answer
161 views
Which Database to choose: MySQL or Oracle
I have an application generating time series data (32 channels, 22KHz, 6 secs) once a minute. These have to be stored in a database. At the moment I'm using MySQL with InnoDB tables ...
1
vote
1answer
72 views
SQL Server to compress the backup file from procedure
Is it possible to compress a backup file to .zip (or another) in a stored procedure invoked from a maintenance plan?
My maintenance plan contains these steps:
check DB (consistency, re_index, maybe ...
1
vote
1answer
116 views
What program to use for the best compression ratio for DB2 log files?
What linux program to use to compress DB2 log files with the best compression ratio?
UPDATE
I thought that these log files would be text type files. But viewing them didn't prove this. I tried to ...
1
vote
1answer
81 views
Oracle SecureFile Compression
Where can I read database compression properties after the creation of an oracle database / tables? Is there a special view where the info is stored and can be retieved?
