Disk space control for PowerPivot: This update introduces two new configuration settings that let you determine how long cached data stays in the system.”.
#Microsoft sql server 2008 r2 64 bit download upgrade#
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.
0 kommentar(er)
