"Michael Cheng [MSFT]" wrote:

> Hi, MZeeshan
>
> Sorry for the delay!
>
> From your descriptions, I understood you would like to know SQL Server
> Analysis Services capabilities. If I have misunderstood your concern,
> please feel free to point it out.
>
> Since this is a consultation type issue, you can contact Advisory Services
> (AS) . Microsoft Advisory Services provides short-term advice and guidance
> for problems not covered by Problem Resolution Service as well as requests
> for consultative assistance for design, development and deployment issues.
> You may call this number to get Advisory Services: (800) 936-5200.
>
> Personally, here is some answers to your questions
> > 1. What is the maximum size of database that can be recommended for an
> > Enterprise Datawarehouse? (our estimate is 1 TB)
>
> > 2. What are the limitations for total number of dimension/fact tables?
>
> For both 1 and 2, check the MSDN Online link below
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/ag
> ref_4vlf.asp.
>
> > 3. What are the hardware requirements for such a system (based on #1 and
> #2)?
> > It's hard to say and I am afraid you will have to consult our Advisory
> Services guys
>
> > 4. Can their be some tabular comparison available b/w SQL Server and DB2
> on some of those standard > benchmarks? I checked the comparison page and
> saw some of the videos but I am looking for some
> > concise information.
>
> To SQL's benchmark, please visit
> http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp
>
> > 5. Are there any companies who are successfully implementing SQL Server
> based data warehousing
> > solutions? who are they and how big are their datawarehouses.
>
> http://www.microsoft.com/sql/evaluation/casestudies/solutions.asp#business
> http://www.microsoft.com/china/sql/evaluation/overview/2000/fastfacts.asp
>
> > 6. Will there be any improvements in SQL Server 2005 in this regard?
>
> SQL Server 2005 is not public relased yet, you could post in the newsgroup
> below to discuss with our developers
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
>
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>