If you have a lot of repeating data, then table-level page compression will be your best friend. The order of your data matters also. Because SQL Server compresses at the page level, repeating ...