Choosing an edition of Microsoft SQL Server 2008 R2 is an important step when planning a Microsoft SharePoint Server 2010 deployment. This paper describes the benefits of deploying on SQL Server 2008 R2 Enterprise Edition and scenarios in which its features can be applied.
Download this white paper as a Word document (.docx) (http://go.microsoft.com/fwlink/?LinkID=187264).
Workload
EE
SE
Notes
Remote BLOB Storage (RBS) on a non-local device
Y
N
Enables an administrator to externalize SharePoint binary large object (BLOB) data by hosting it on less expensive, commodity hardware solutions and managing it with SQL Server
Store files and documents on cheap hardware
Snapshot support for site collection backup and content deployment
Elimination of any data loss or corruption while backing up a site collection or exporting a site
Enterprise performance and reliability enhancing SP availability / Disaster Recovery
Data Compression for Search Crawl and Property databases
Reduce data storage costs and improve performance
Storage savings and Efficiency gains
Table partitioning for Web Analytics Reporting databases
Fast and efficient query execution across large databases
Efficiency and Productivity gains
PowerPivot in SharePoint
PowerPivot gives users the ability to analyse massive quantities of data, publish to share discover. IT departments can monitor and manage how users collaborate
Self Service in-memory analytics Business Intelligence