displaying top 100 results
Eric Cobb Good approach! One thing to note about using data compression in SQL Server, if your table does not have a clustered index on it, compression may not behave like you would expect.
When compressing a Heap (a table w/o clustered index), SQL Server will only compress the data