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?