In this article you will learn how to perform compression in SQL Server.
Overview The database is a crucial part of any organization. The main challenge is actually how to manage space because of the ever growing MDF and LDF size just keeps on growing day by day, and the more data the more the SQL Server engine has to perform day in and day out. Consider a scenario where there are n million rows and size of the database is 10 TB -- now just consider how much load and SQL Server engine performance. Example Consider lots of books on your bookshelf. Now just pick one book -- and even that book has some empty pages. Similarly SQL Server works the same way; the empty pages may contain bits of data but consider the whole book and calculate it and you will find plenty of space available. Introduction SQL Server 2008 and later provides an option of Data Compression. As there are two types of compression, Page and Row compression.
Let’s Start: We will be using Local PC. Try it on UAT Server where there is lot of Data, and then you will abel to see the difference in both:
Let's Look at the GUI. A popup will open. Click On next. Click on Row level and Click On Calculate Button it will estimate the Size in MB. Just Click Next. Click Next and See the details. Click On Finish. A Script will get generated; just run that script. Same with Page level. Conclusion This was Compression on SQL Server . Kindly let me know your queries pertaining to this article.
Functions in SQL Server: Practical Guide