Hot answers tagged compression
As the documentation you alredy have linked states, ROW compression uses only the bytes that are needed. Once ROW compression is in use, the CPU cycles used to convert from/to int or bigint are the same: I would not worry about that. BTW, if you're not sure whether int/bigint has an impact on the database size or not (it hasn't), you can see for yourself ...
Only top voted, non community-wiki answers of a minimum length are eligible