Browse by Tags

All Tags » General » Service Pack (RSS)
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: ,
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: , ,
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: , ,