SQL Server Report Builder 3.0 for SQL Server 2008 R2 SP1 CTP – an improved version of the Report Builder. The SQL Server 2008 R2 SP1 Feature Pack CTP1 comes with 15 individual packages separately compiled for x86, AMD64 or IA64: This feature allows to control the amount of time cached data is kept and how long an unused database is kept in memory before is unloaded.
Disk space control in PowerPivot for SharePoint. #SQL SERVER 2008 R2 SP1 NATIVE CLIENT DOWNLOAD UPGRADE#
The new DAC enables the upgrade of the database schema to SQL Azure.
Data-tier Application Component Framework (DAC Fx) for improved database upgrades. 
FORCESCAN – a new query hint – has been added allowing ‘scan’ as the access method of the index. The FORCESEEK index hint syntax now allows optional parameters for better control of the access method on the index.
ForceSeek for improved querying performance. OS configurations and resource conditions related to an SQL Server instance are monitored with new DMVs and XEvents on performance counters. sys.dm_query_stats DMV has additional columns for troubleshooting long-running queries. Dynamic Management Views for increased supportability. Microsoft has announced the availability for download of SQL Server 2008 R2 SP1 CTP, including all cumulative updates, and SQL Server 2008 R2 SP1 Feature Pack CTP1, containing a number of stand alone tools adding more value to SQL Server 2008.īeside a large number of bugs fixed, SQL Server 2008 R2 SP1 CTP comes with the following notable new features:
0 kommentar(er)
