Add Page Compression To Every Table In Your SQL Database The Winston Wolf Way

So you need to add page level compression to every table in your SQL Server database? I'm not going to judge you. I'm not going to tell you it's a good idea or a bad idea. I needed to do it in my DEV environment and maybe you need to do it in your production… Continue reading Add Page Compression To Every Table In Your SQL Database The Winston Wolf Way

Set DATA_COMPRESSION for all tables

Working on a quick little project to sync up two databases and I realized the data compression was set differently between the two of them. Apparently, my Google fu was not up to snuff because it took quite a bit of stumbling around to find a forum post matching what I wanted to do.  There… Continue reading Set DATA_COMPRESSION for all tables