1

I have few Clarification regarding AWS RDS SQL Server.

Do we have any compression technique to compress the data loaded into RDS SQL server? Is there any option or parameter to compress the data and load into RDS SQL server?

1

After you have loaded the data into a table, and as long as you have signed up for a 2016 Standard Edition or above, you can use the Data Compression that is included within Sql Server:

CREATE TABLE t1
(
    ... -- whatever columns you need.
)
WITH 
(
    DATA_COMPRESSION=PAGE
);

You can also create compressed indexes in a similar fashion:

CREATE INDEX idx_t1 ON t1(...) WITH (DATA_COMPRESSION=PAGE);

For more information, check out the documentation for Enabling Compression on a a Table or Index.

  • Mr.Brown.. Thank you for the details. I will test the same and also see how the performance will be after compression. – Raam Apr 13 at 13:29
  • Brown, Just need need to know, what could be the main difference between PAGE and ROW compression. For example, My table is suppose to process or load more than 10 millions of records in alternate days. So table compression with PAGE or ROW, which one could be possible option for the benefit of performance, storage etc. – Raam Apr 13 at 15:47
  • You will always get the best compression with page. Also, it stays compressed when it is bought into the buffer pool and therefore you can fit more in memory. I download circa 300 million rows a day, I hardly notice the overhead of compressing the data. Query performance is also better because it results in less IO - win, win! – Mr.Brownstone Apr 13 at 16:27
  • Excellent!.. probably I am looking to test the same and see the best result of it. Thanks once again – Raam Apr 13 at 18:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.