An Important note if you are planning to setup GP 10 with the recently released SQL Server 2008 R2 - Service Pack 5 for Microsoft Dynamics GP 10.0 required. Service Pack 5 is scheduled to be released in the summer of 2010.
You would get the error - “your current SQL Server is not a supported version” if you try to install GP 10 with SQL 2008 R2.
GP 2010 is supported out of the box - Microsoft SQL Server 2008 R2 - Enterprise Edition or Standard Edition
SQL Server 2008 has better support and integration for the PowerPivot feature in Office 2010 among many other things. People have reporting using PowerPivot with large amount of data. Microsoft says that with enough memory, 100 million rows can be imported.
Some other really cools things about SQL Server 2008 R2
1. SQL Server 2008 R2 can now scale with Windows Server 2008 R2 up to 256 logical processors.
2. Utility Control Point, which enables a centralized view of SQL Server instances and database applications and their utilization across the designated managed server group
3. Utility Explorer that provides a tree view of the servers, and a dashboard with summary information on the servers.
4. A new Unicode compression scheme, USC-2, can save up to 50% of storage requirements with Unicode data.
Check out the SQL Server 2008 R2 Feature Pack here
Microsoft seems to be producing nice videos about everything – See R2 Videos here - http://www.microsoft.com/sqlserver/tour/en/videos.aspx