SQL Server 2008 SP 3
SQL Server 2008 SP 3
Written by Kay Ewbank   
Wednesday, 12 October 2011

Microsoft SQL Server 2008 Service Pack 3 has been released with cumulative updates and a few minor improvements.

The improvements start with optimized query outcomes when an indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor). Another improvement fixes the problem that used to occur if you had transparent data encryption enabled and the certificate was dropped. Transparent data encryption will now be available even under these circumstances.

If you’re using SQL Server Integration Services, the logs will now show the total number of rows sent in Data Flows.

If you’re trying to upgrade from a previous version of SQL Server to 2008 SP3, the experience has apparently been improved, though gotchas are still there if you’ve done something adventurous like install a pre-release version of SQL Server 2008 or Visual Studio 2008. In such cases you’ll need to follow the instructions carefully as to which bits to uninstall and reinstall, and what order to do it in. 

 

 

The service pack is available for both the full and Express editions of SQL Server 2008 - see links below.

More information

SQL Server 2008 SP3 Release Notes

Download SQL Server 2008 Service Pack 3

SQL Server 2008 SP3 Express Edition

 

Related article on I Programmer:

SQL Server 2008 R2

 

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Twitter or Facebook or sign up for our weekly newsletter.

 

Banner


Is OpenOffice Heading to the Apache Attic?
05/09/2016

After a long and chequered history spanning over 30 years if you count its proprietary forebears, OpenOffice, the free open source suite of productivity software, is on the brink of closure due a [ ... ]



Salesforce Launches AI Einstein
21/09/2016

Saleforce has shown off a wrapper for its CRM products that uses AI and machine learning to improve recommendations, choosing to unveil it and other innovations this week, rather than waiting for the  [ ... ]


More News

Last Updated ( Wednesday, 12 October 2011 )
 
 

   
Banner
RSS feed of news items only
I Programmer News
Copyright © 2016 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.