title: SQL Server compression
body: <p>When inserting into a compressed table, will the data be compressed into the log file or will it be compressed when the checkpoint runs and the data is written to the data files? </p>