Read this it may give your query answer.
Overview of New Features in Microsoft SQL Server 2008 R2
Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users, Developers and Database Administrators. This article gives you an overview of some of the new features in SQL Server 2008 R2.
Capitalize on Hardware Innovation
There was always a demand from customers to increase the number of logical processors supported in SQL Server. In SQL Server 2008 R2 the number of logical processors supported has been increased from 64 to 256 and it will take advantage of the multi-core technology. This will help improve performance and scalability for very large data warehousing applications.
Optimize Hardware Resources
This is a great new feature for database administrators as it will provide a real time insight into Server Utilization, Policy Violations etc. This feature will help organizations to strictly apply organization wide policies across servers thereby helping them maintain a healthy system.
Manage Efficiently at Scale
This feature will help database administrator to gain insight into growing applications and databases thereby helping them to ensure better management of database servers.
Enhance Collaboration Across Development and IT
Database Application development will be more closely integrated with Visual Studio 2010 which will help to ensure higher quality during the application development along with easier deployments and better handling of changes over time.
Master Data Services (MDS)
A Master Data Service (MDS) is a kind of data service that is responsible for: managing, in a single place, the uniqueness, integrity, quality, and interrelationships between the data that matters the most. This will improve the quality of your data because of centralized approach of defining; deploying and managing master data thereby ensure reporting consistency across systems.
Build Robust Analytical Applications
Using Microsoft Office Excel 2010 you can build robust analytical applications which will allow in-memory, column oriented processing engine to allow users to interactively explore and perform complex calculations on millions of data at lightening speeds. Using Microsoft Excel 2010 you can easily integrate data from multiple sources such as corporate databases, spreadsheets and external data sources.
Share and Collaborate with Confidence
Using Microsoft Office SharePoint 2010 users can easily publish reports to SharePoint sites thereby making it available across the organizations. The other advantage is that the reports can be refreshed automatically and you can also maintain version controlling and tracking using SharePoint. Once you start using Microsoft Office SharePoint the SharePoint Administrators will have the ability to set server policies and monitor them more effectively thereby securing the business critical information.
Support for Geospatial Visualization
Microsoft SQL Server 2008 R2 will provide support for geospatial visualization including mapping, routing, and custom shapes. It will also support SQL Spatial and will also provide integration with Microsoft Virtual Earth tiles.
Read more: New Features in Microsoft SQL Server 2008 R2 - MyTechMantra.com http://www.mytechmantra.com/LearnSQLServer/Microsoft_SQL_Server_2008_R2.html#ixzz1MUC7PkC9
Read more: New Features in Microsoft SQL Server 2008 R2 - MyTechMantra.com http://www.mytechmantra.com/LearnSQLServer/Microsoft_SQL_Server_2008_R2.html#ixzz1MUBwhj3d