![]() SQL Server 2008 R2 Command Line Utilities – this utility enables users to “connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 20 R2 instances.” SQL Server 2008 R2 Native Client – provides run-time support for using native code APIs to connect to SQL server 2000, 2005, or 2008. SQL Server 2008 R2 Remote Blob Store – useful to store blobs of unstructured data in external data stores. Microsoft® System CLR Types for SQL Server 2008 R2 – contains the “components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2”. Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 – provides interconnection with SAP NetWeaver BW version 7.0. SQL Server 2008 Reporting Services Add-in for SharePoint Technologies 2007 – provides reporting environment integration with SharePoint 2007. SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 – provides reporting environment integration with SharePoint 2010. SQL Server PowerPivot for Microsoft Excel – a data analysis tool for Excel. 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.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |