Have other people here played with SQL Server 2008 Compression at either the page or the row level on their datasets much? What have your impressions been on performance both speed and disk-space wise?
Has anyone ever seen compression demonstrably hurt performance?
On some of our huge fact tables we've been playing around and noticing that compression can make a hugely beneficial query speed difference on both tables and its indexes. It's also been saving a lot of disk space (~50% on some data). Our hardware setup is severely disk/io bound relative to the processor and compression so far seems like a trivially easy performance win for us.