There are no less than three editions of SQL Server 2008 R2 SP1 Express: In addition to SP1 for the paid versions of the data platform, Microsoft also upgraded SQL Server 2008 R2 Express Edition with the advent of SP1.īut even with the upgrade, SQL Server 2008 R2 SP1 Express Edition continues to be available free of charge to customers. Disk space control for PowerPivot: This update introduces two new configuration settings that let you determine how long cached data stays in the system.”.Data-tier Application Component Framework (DAC Fx) for improved database upgrades: The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management.ForceSeek for improved querying performance: Syntax for FORCESEEK index hint has been modified to take optional parameters allowing it to control the access method on the index even further.Dynamic Management Views for increased supportability: sys.dm_exec_query_stats DMV is extended with additional columns to improve supportabilities over troubleshooting long-running queries.In addition, according to Microsoft, SQL Server 2008 R2 SP1 brings to the table enhancements including: SQL Server 2008 R2 SP1 comes packed with all the cumulative updates for the data platform, namely packages 1 thru 6, as well as a variety of bug fixes that the software giant has introduced in response to customer feedback.

Customers running Microsoft’s data platform can head over to the Download Center and grab SQL Server 2008 R2 Service Pack 1 and SQL Server 2008 R2 SP1 - Express Edition.Īccording to Microsoft, Service Pack 1 is designed to upgrade all SKUs of SQL Server 2008 R2, namely editions such as Parallel Computing, Datacenter, Enterprise and Developer, Standard, Web, Workgroup, and Express. The first upgrade to SQL Server 2008 R2 is now available for download from Microsoft.

Microsoft sql server download 2008 r2