In my previous article I’ve posted about slipstream and we have discussed about it’s methods. In this article I’m going to write about creating basic slipstream setup in SQL Server 2008. In this method you will be merging the service pack with the base setup at the time of installation. This method is very simple and straight forward. The merged setup package cannot be reused and it’s valid only for that particular (single) installation.
Category Archives: SQL Server 2008 - Page 2
SlipStream in SQL Server 2008 Setup
Posted by Vidhya Sagar
on December 30, 2009
No comments
Slipstream is a feature expected in earlier version of SQL server itself however from SQL Server 2008 SP1 it’s included. This is one of the most expected thing in SQL Server by DBA’s since windows operating system has the feature already and the system admin’s can easily update their setup packages. Now we have the capability to merge service pack with the base setup of SQL Server 2008. There are two methods of slipstream creation available and they are below
Types of Data Compression – SQL Server 2008 – Part 3
Posted by Vidhya Sagar
on November 27, 2009
No comments
In my previous article we have seen the need for compression, goal of compression etc. In this article we are going to discuss the types of compression supported in SQL Server 2008. There are two types of compression supported and they are
- Row Level Compression and
- Page Level Compression
Lets discuss on each compression type
Data Compression – SQL Server 2008 – Part 2
Posted by Vidhya Sagar
on November 10, 2009
2 comments
In Part1 article I’ve described the need for compression in SQL Server and also gave a brief on Compression enhancement overview. As a next step, in this article I’m going to describe the existing compression techniques, overview of basic compression techniques and goal of compression. Now the questions hits your mind is, why do we need to know the basic techniques? First we need to understand the basic compression techniques available and how it works, this will be the base to understand the compression technique used in SQL Server. Lets discuss on this one by one
Data Compression – SQL Server 2008 – Part 1
Posted by Vidhya Sagar
on November 3, 2009
1 comment
Data compression is an enhanced feature available in SQL Server 2008. Database compression in SQL Server is introduced with SQL Server 2005 SP2 onwards where we have the capability to compress VARDECIMAL data type. This compression works when the actual value is less than the declared value, all the remaining values will be removed there by compressing the empty space. In SQL Server 2008 we have native compression techniques added to reduce the size of your database.