in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Service Pack » General (RSS)

Browse by Tags

  • 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 4 (though I haven't tested it myself). What is annoying...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Dec 12 2007

  • 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 here (Note the Date Published has changed). Below...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Mar 7 2007

  • 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 against the additional CPU usage that is required...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Sun, Feb 25 2007

  • 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 (SP2) Download Feature Pack for Microsoft SQL Server...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Mon, Feb 19 2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems