One thing you have to keep in mind when designing and creating a data warehouse is that you have to regularly backup your database. It's very frustrating to put in a long week of hard work into a project just to start over in the event that you lose your data. As with many operations in SQL Server, there are two different ways to backup your database: you can do it with a t-sql script or with an easy to use GUI in SQL Server Management Studio. To use the graphical user interface, right-click on ...
Read More
In this blog I will shed some light on exactly what goes on behind the scenes when using data compression in SQL Server 2008. Hopefully this will better help you decide which option is best for your scenario without taking a stab-in-the-dark approach to it. When you add compression to an object in your database, you are storing all of the fixed length data types as variable length and then adjusting the data type by determining how much space is required for that value. In ROW compression, for e...