Notes about SQL Server 2008 R2 SP1

  Hi, The purpose of this post is to share some notes (links) about the recent release of SQL Server 2008 R2 SP1: SQL Server 2008 R2 SP1     Technorati Tags: SQL Server 2008 R2 SP1,Service Pack       Download     http://www.microsoft.com/download/en/details.aspx?id=26727           List of bugs that are…


Can log files growth affect DML? Post-CU Update

Hello all, A while back I blogged on how log files can affect DML performance, depending on their structure and growth ratio. It recently came to my attention (thanks Paul Randal) that a fix was published late last February, in KB2455009, aimed at scenarios where one might experience slow performance when recovering a database, if…


Latest updates available are…

Hello all, Because in the last 30 days some major updates were released for several versions of SQL Server (from which the last two listed here were released just last night), this serves as a quick gather of the ones available. Remember that CUs (Cumulative Updates) include all fixes since the last RTM or SP,…


SQL Server 2008 SP2 is out!

The SQL Server 2008 SP2 has major improvements that include integration of reporting services with SharePoint products and several management improvements. This final version of the Service Pack 2 includes new compatibility features with SQL Server 2008 R2 and hotfix solutions provided in SQL Server 2008 SP1 Cumulative Updates 1 thru 8. For example, with…


Security Update – MS09-062

Hello, Normally, two releases of a SQL security update are released: GDR (General Distribution Release) QFE (Quick Fix Engineering) The GDR release must be applied to all the SQL Server instances that keeps the RTM build or for the cases where only a Service Pack was installed. The QFE release must be applied for the…