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