Skip to Content
Former Member
Aug 04, 2005 at 06:23 PM

Compression on SQL Server 7.0


Does anyone have experience of compression on SQL Server 7.0?

Is the E table structured any differently than the F table. For e.g. in Oracle, F table is partitioned by request ID and E by time. So even, if number of records is not reduced during compression, performance improves.

Any other suggestions for improving performance on SQL server like do not use auto update on stats or something?