Tag: sql server 2008

  • DotNet 3.5 on Windows 7 to Install SQL Server 2008

    This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks Im seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5…

  • Basic Slipstream Setup

    In my previous article Ive posted about slipstream and we have discussed about its methods. In this article Im 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…

  • Configuring Data Compression

    In this article we are going to configure Data compression in SQL Server 2008. Configuring data compression is very easy with just an couple of steps. The steps are below Estimate the Compression Ratio (Optional) Configure Data Compression

  • Variable and Assignment enhancements

    Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers. Declare Statement Compound Assignment Operators Row Constructors Table Valued Parameter (TVP) Lets discuss on this titles one by one

  • Activity Monitor

    Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU…