search

BobPusateri / blog-comments

0 stars 0 forks source link

Does Data Compression Speed Up Datatype Changes? | Bob Pusateri #2

Open utterances-bot opened 6 months ago

utterances-bot commented 6 months ago

Does Data Compression Speed Up Datatype Changes? | Bob Pusateri

Does data compression make changing data types faster? Let's dig in and find out!

https://bobpusateri.com/2024/04/compression-datatype-change/

EitanBlumin commented 6 months ago

This is similar to a blog post published by Paul White several years ago: https://sqlperformance.com/2020/04/database-design/new-metadata-column-changes-sql-server-2016

But there are issues with this feature, making it rather useless especially in the use cases where it would have been most beneficial.

I published a sort of 'response' blog post to it here:

https://eitanblumin.com/2020/05/04/the-new-metadata-only-column-changes-feature-in-sql-server-2016-is-useless/

BobPusateri commented 6 months ago

Interesting! Thank you for sharing these!!

KevinKlineSQL commented 1 month ago

Just curious about why you chose only row compression, rather than showing both row and page compression, especially since page compression is far more popular and effective in most OLTP workloads?