Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Estimating Data Compression Savings in SQL Server

Glenn Berry
5.51K subscribers
<__slot-el>
<__slot-el>
1.6K views 4 years ago ELIZABETH
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not. It is applicable for SQL Server 2008 and newer. You can download the script used in this video here: http://bit.ly/3kV5GKT ⏱️TIMESTAMPS⏱️ 0:00 Intro 0:16 What is data compression? 0:53 How does data compression work? 2:45 Looking at what the queries do 5:53 Running the query 6:15 Looking at the results 10:33 Recapping the feature 10:45 Puppies! 🔴 Please subscribe for more content like this! SOCIAL =============================== 📝 - BLOG: https://glennsqlperformance.com/ 🐦 - TWITTER:   / glennalanberry   👥 - FACEBOOK:   / glenn.berry.92   LinkedIn:   / glberry   Host, Video: Glenn Berry ...more
...more
Estimating Data Compression Savings in SQL Server
57Likes
1,667Views
2021Mar 9
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not. It is applicable for SQL Server 2008 and newer. You can download the script used in this video here: http://bit.ly/3kV5GKT ⏱️TIMESTAMPS⏱️ 0:00 Intro 0:16 What is data compression? 0:53 How does data compression work? 2:45 Looking at what the queries do 5:53 Running the query 6:15 Looking at the results 10:33 Recapping the feature 10:45 Puppies! 🔴 Please subscribe for more content like this! SOCIAL =============================== 📝 - BLOG: https://glennsqlperformance.com/ 🐦 - TWITTER:   / glennalanberry   👥 - FACEBOOK:   / glenn.berry.92   LinkedIn:   / glberry   Host, Video: Glenn Berry

Follow along using the transcript.

Glenn Berry

5.51K subscribers