Q

Pros and cons of data warehousing with SQL Server 2000

I was wondering if you could quickly outline the pros and cons of data warehousing with SQL Server 2000.
The pro for the business is a system to support decision making. The pro for IT is the opportunity to work on a new system. The con is if the project is improperly planned and managed, it could require a great deal of time and budget. Data warehousing projects are typically long term, but can offer many benefits to the organization from a tactical and strategic perspective.


Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in June 2005

Dig deeper on Microsoft SQL Server 2000

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close