Browse by Tags

All Tags » Service Pack (RSS)
11 August 2008 21:05

Visual Studio 2008 Service Pack 1 RTM download now available

As mentioned in a previous post , parts of SQL 2008 require you to have Visual Studio 2008 SP1 RTM installed if you had previously installed Visual Studio 2008 prior to installing SQL 2008. Today, Visual Studio 2008 Service Pack 1 RTM is available for...
Posted by sqldbatips | with no comments
Filed under: , ,
10 July 2008 15:51

Important Security Update for SQL Server MS08-040

Microsoft have released a set of security updates for SQL 7, 2000 and 2005 to resolve four privately disclosed vulnerabilities. For details of the affected systems and vulnerabilities see Microsoft Security Bulletin MS08-040 . Note that if you have already...
Posted by sqldbatips | with no comments
Filed under: ,
12 December 2007 18:34

Processadmin server role broken by SQL2005 Cumulative Update 3

After you apply SQL 2005 Cumulative Update 3 (3186), members of the processadmin fixed server role can no longer kill spids (which since that is all that role allows you to do effectively makes it useless). This is supposedly fixed in Cumulative Update...
Posted by sqldbatips | with no comments
Filed under: ,
11 April 2007 23:50

SQL 2005 SP2 Re-release and post fixes explained

If you're as confused about what's going on with SQL 2005 SP2 and the various post SP2 hotfixes as I am, Bob Ward from PSS has a very detailed explanation of the various permutations here . Hopefully this will help clear up much of the confusion!
Posted by sqldbatips | with no comments
Filed under:
13 March 2007 23:35

Windows 2003 Service Pack 2 released

Windows Server SP2 has been released. The download page is here . There is a performance improvement for SQL Server 2005 around the winsock API but it's most noticeable in higher end (>8CPU + multi NIC) hardware running workloads that show a high kernel...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
08 March 2007 07:23

SQL 2005 Performance Dashboard Custom SSMS Reports available

As I've previously blogged about, SQL 2005 SP2 allows users to write custom reports that are hosted in SSMS and are available via the Reports context menu in Object Explorer. Microsoft have now released a group of reports that can be used to troubleshoot...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2007 15:02

Another SP2 Maintenance Plan bug - Database Integrity Checks

** Update: A hotfix is now available to address this issue here for SQL versions 3042 through 3053** ** Update: A hotfix is now available to address this issue here for SQL versions 3150 through 3158** Tony has picked up on another issue with SP2 in regard...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2007 13:33

SQL Server 2005 Service Pack 2 Rereleased

As a response to the bug introduced in SP2 with regard to maintenance plan cleanup tasks ( KB 933508 ) Microsoft have released an updated build of SQL Server 2005 SP2 which replaces the originally released service pack. The updated release is available...
Posted by sqldbatips | 2 comment(s)
Filed under: ,
25 February 2007 21:04

Estimating vardecimal storage savings in all databases

One of the new features in SQL Server SP2 is the vardecimal storage format which can be used to significantly reduce the space required by decimal and numeric columns in a table at the cost of a small CPU overhead. The storage savings must be balanced...
Posted by sqldbatips | with no comments
Filed under: , ,
24 February 2007 14:50

Maintenance Plan Changes in SQL Server 2005 SP2

** Updated please check here for details of hotfix ** Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected? You are affected if you...
Posted by sqldbatips | 3 comment(s)
Filed under: , ,
21 February 2007 11:56

Updated SQL Sever 2005 sample databases and code (Feb 2007)

You can download the latest versions of the SQL Server 2005 samples and databases using the link below.There is also a new sample database called AdventureWorksLT. This is a scaled-down sample database that those who are new to SQL Server will find easier...
Posted by sqldbatips | with no comments
Filed under: , ,
19 February 2007 17:00

SQL 2005 Service Pack 2 now available

Get it while it's hot! Download SQL 2005 Service Pack 2 Readme for Microsoft SQL Server 2005 Service Pack 2 What's New in SQL Server 2005 SP2 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 Download SQL 2005 Books Online Feb 2007 ...
Posted by sqldbatips | 3 comment(s)
Filed under: , ,
20 December 2006 17:42

SQL 2005 Service Pack 2 December CTP now available

The December CTP of SQL Server 2005 Service Pack 2 is now available for download here . You can also download the latest CTP of SQL Server 2005 Books Online (BOL) from here . One of the changes which I mentioned in an earlier post is that custom reports...
Posted by sqldbatips | with no comments
Filed under: ,