April 9, 2013 at 12:10 am
Hi,
Is Parallel Data Warehouse feature of SQL Server 2008 R2 targeted only for OLAP/BI impementations?
Can we use it for hosting OLTP databases as well?
Thanks.
April 9, 2013 at 12:20 am
http://msdn.microsoft.com/en-us/library/ee730351.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 11, 2013 at 3:06 pm
praveen_vejandla (4/9/2013)
Hi,Is Parallel Data Warehouse feature of SQL Server 2008 R2 targeted only for OLAP/BI impementations?
Can we use it for hosting OLTP databases as well?
Thanks.
ABSOLUTELY NOT!! It is purpose built from the ground up for large scan aggregates.
What you MAY want to check out is Hekaton. If you have seriously high transaction volumes MS may let you in on the TAP.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply