Q

Oracle versus SQL Server for data warehouse

Given that money is not neccessarily the determining factor, which platform, MS SQL Server or Oracle, would you suggest as the foundation of a data warehouse/BI solution? We are looking to implement a data warehouse to analyze student test scores and present data to end users.

The decision on SQL Server versus Oracle comes down to the size of your implementation. Oracle can handle data...

warehouses up into the 1-2TB range before you have to really start getting advanced in your performance tuning tactics. SQL Server's ceiling is well below that level.

Oracle will run fine on the Wintel platform as well as any of the mainstream Unix platforms. SQL Server is is much more tied into the Wintel platform.


This was last published in March 2005

Dig Deeper on Oracle data warehousing

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close