Some people get significant savings, some don't. You'd have to test. There are some scripts here you could use to test (http://blogs.msdn.com/sqlserverstorageengine/archive/2007/11/13/estimating-the-space-savings-with-data-compression.aspx), and you could use Developer edition to run tests.