Service Pack 2 for SQL Server 2008 R2 released
With Service Pack 2 for SQL Server 2008 R2, Microsoft has released a bundle of patches for its database server. The update fixes several bugs with the product, most notably a problem that could cause a deadlock of the server when synchronising database logs to another server. A bug that prevented users of the JDBC Driver to connect to the server when using JRE 6 update 29, or later, was also fixed.
A problem where users receive "incorrect results" when running "a complex query" which contains joins and aggregate functions and uses the DISTINCT statement has been fixed, but Microsoft is not offering any further details on it. Other patches correct false error reports, fix problems with the server's update install mechanism and more.
The Service Pack is available for download from Microsoft's Download Center and does not require an additional service contract with the company. A free-of-charge version of SQL server is available with the Express Edition.