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 Comments
Leave a Reply. |