From Dev.to
ROW VS PAGE VS COLUMNSTORE VS ARHIVE DATA COMPRESSION on SQLServer
Storage and the size of your database can become a real danger if you don't actively monitor your table sizes, archive old data, and implement compression. Moving from lowest to highest storage savin...