Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 SQL Server 2008 Standard vs Enterprise

Author  Topic 

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-01-08 : 16:05:37
I am setting up an OLAP environment for a readonly database, replicated from a publisher which is about 85 gigs in size, growth is about 2.5 gigs /month. Just wondering if I need the Enterprise version? I have tight budget constraints, the main advantage I can see is table and index partitioning, which might be important. Any suggestions would be appreciated, thank you.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-08 : 16:28:13
SQL Server 2008 Standared covers most aspects of replication

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-08 : 17:39:08
have a look at this: http://msdn.microsoft.com/en-us/library/cc645993.aspx

under tight budget constraints i'd go with SE unless there are features you must have. partitioning is nice, but you can likely get by fine without it
Go to Top of Page

behrman
Yak Posting Veteran

76 Posts

Posted - 2010-01-09 : 11:44:52
Enterprise
SQL Server 2008 Enterprise is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications.

Standard
SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications.



RAQ Report: Web-based Excel-like Java reporting tool
Go to Top of Page

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-01-18 : 14:56:52
Thanks, you guys are awesome. I am assuming there are no limitations with using Standard edition and Sharepoint 2007 especially things like dashboards and whatnot?
Go to Top of Page
   

- Advertisement -