Hello friends,Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature. ** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition. ** This feature is not available in SQL Server 2005’s Standard edition. I hope by the name it is …
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip we will take implement the data compression with basic steps.So lets follow the steps1) Right click on the table on which you need to implement compression. You will get following menu just select …
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space. It is worst condition when you are on a dedicated hosting or cloud hosting with limited space. In such case “Compression” …