SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper)

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) (https://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	Y	N	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	Y	N	Reduce data storage costs and improve performance Storage savings and Efficiency gains
Table partitioning for Web Analytics Reporting databases	Y	N	Fast and efficient query execution across large databases Efficiency and Productivity gains
PowerPivot in SharePoint	Y	N	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