Board index MS SQL Server

Is OLAP better in SQL 2000

Is OLAP better in SQL 2000

Post by Andy Rittin » Sat, 19 Aug 2000 04:00:00



We just installed a new production server with Win2k and SQL Server 7 to run
our Data Marts that we've been developing on NT4 with SQL Server 7.  Should
we upgrade to SQL 2000?  Is it any better?

 
 
 
Top

Is OLAP better in SQL 2000

Post by Amir Net » Sat, 19 Aug 2000 04:00:00


No. SQL 2000 was design from the ground up to be much worst then SQL 7.

Just kidding.

Hey, we spent 18 months adding tons of features and improving scalability
and performance across the board. I sure hope this means that SQL 2000 is
better...

If you have an existing application then just the performance improvements
should be enough of an incentive to upgrade. If you are still building new
cubes I am sure you'll be impressed with the number of features and
capabilities that were added to the system.

Amir.


| We just installed a new production server with Win2k and SQL Server 7 to
run
| our Data Marts that we've been developing on NT4 with SQL Server 7.
Should
| we upgrade to SQL 2000?  Is it any better?
|
|

 
 
 
Top

Is OLAP better in SQL 2000

Post by Andy Rittin » Tue, 22 Aug 2000 04:00:00


SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability
to Admins and Users

This article really didn't cover any of the new features for building cubes
or how the performance improvements will help OLAP services.   Of course I
want the latest and greatest, but I'm going to need some better info to
convince my CIO.


> No. SQL 2000 was design from the ground up to be much worst then SQL 7.

> Just kidding.

> Hey, we spent 18 months adding tons of features and improving scalability
> and performance across the board. I sure hope this means that SQL 2000 is
> better...

> If you have an existing application then just the performance improvements
> should be enough of an incentive to upgrade. If you are still building new
> cubes I am sure you'll be impressed with the number of features and
> capabilities that were added to the system.

> Amir.



> | We just installed a new production server with Win2k and SQL Server 7 to
> run
> | our Data Marts that we've been developing on NT4 with SQL Server 7.
> Should
> | we upgrade to SQL 2000?  Is it any better?
> |
> |

 
 
 
Top

Is OLAP better in SQL 2000

Post by dp.. » Tue, 22 Aug 2000 04:00:00


Actually, I am in a similar predicament wrt. Analysis Services 2000.
Based on various Web discussions and tantalizing tit-bits from the
cognoscenti like Amir N. and Nigel P., I am very motivated to upgrade
(and will probably do so on a test server anyway). But it would be nice
to have a detailed technical article or seminar slides that lay out all
the new benefits. Whereas Microsoft has come thru town a couple of
times with free seminars discussing the new features of SQL Server 2000
in general, I did not come across any such offering that focuses on AS
2000 (which, by Amir's account, definitely deserves an exposition).



> SQL Server 2000: New Features Provide Unmatched Ease of Use and
Scalability
> to Admins and Users

> This article really didn't cover any of the new features for building
cubes
> or how the performance improvements will help OLAP services.   Of
course I
> want the latest and greatest, but I'm going to need some better info
to
> convince my CIO.



> > No. SQL 2000 was design from the ground up to be much worst then
SQL 7.

> > Just kidding.

> > Hey, we spent 18 months adding tons of features and improving
scalability
> > and performance across the board. I sure hope this means that SQL
2000 is
> > better...

> > If you have an existing application then just the performance
improvements
> > should be enough of an incentive to upgrade. If you are still
building new
> > cubes I am sure you'll be impressed with the number of features and
> > capabilities that were added to the system.

> > Amir.



> > | We just installed a new production server with Win2k and SQL
Server 7 to
> > run
> > | our Data Marts that we've been developing on NT4 with SQL Server
7.
> > Should
> > | we upgrade to SQL 2000?  Is it any better?
> > |
> > |

Sent via Deja.com http://www.deja.com/
Before you buy.
 
 
 
Top

Is OLAP better in SQL 2000

Post by dennis redfiel » Thu, 24 Aug 2000 04:00:00


Get a copy of the Beta2 and load the BOL to get a look at what's up with
Analysis Services.  Be warned however that althought MS insists that you can
administer both OLAP Services and Analysis Services Servers from a single
client machine, this may provide difficult in the real world.


> Actually, I am in a similar predicament wrt. Analysis Services 2000.
> Based on various Web discussions and tantalizing tit-bits from the
> cognoscenti like Amir N. and Nigel P., I am very motivated to upgrade
> (and will probably do so on a test server anyway). But it would be nice
> to have a detailed technical article or seminar slides that lay out all
> the new benefits. Whereas Microsoft has come thru town a couple of
> times with free seminars discussing the new features of SQL Server 2000
> in general, I did not come across any such offering that focuses on AS
> 2000 (which, by Amir's account, definitely deserves an exposition).



> > SQL Server 2000: New Features Provide Unmatched Ease of Use and
> Scalability
> > to Admins and Users

> > This article really didn't cover any of the new features for building
> cubes
> > or how the performance improvements will help OLAP services.   Of
> course I
> > want the latest and greatest, but I'm going to need some better info
> to
> > convince my CIO.



> > > No. SQL 2000 was design from the ground up to be much worst then
> SQL 7.

> > > Just kidding.

> > > Hey, we spent 18 months adding tons of features and improving
> scalability
> > > and performance across the board. I sure hope this means that SQL
> 2000 is
> > > better...

> > > If you have an existing application then just the performance
> improvements
> > > should be enough of an incentive to upgrade. If you are still
> building new
> > > cubes I am sure you'll be impressed with the number of features and
> > > capabilities that were added to the system.

> > > Amir.



> > > | We just installed a new production server with Win2k and SQL
> Server 7 to
> > > run
> > > | our Data Marts that we've been developing on NT4 with SQL Server
> 7.
> > > Should
> > > | we upgrade to SQL 2000?  Is it any better?
> > > |
> > > |

> Sent via Deja.com http://www.deja.com/
> Before you buy.

 
 
 
Top

1. OLAP services 2000 together with SQL server 2000?

Hello everybody!

Can someone help me with this one?

I have a SQL SERVER 7 system running just fine.
Both the database server and OLAP services are installed together on a
single machine.

Can I upgrade JUST the OLAP services component to SQL SERVER 2000?

So, I want to run the SQL SERVER 7 database and the SQL SERVER 2000 OLAP
services
together on the same machine.

I think this is possible, sine the two components are completely seperated
in SQL SERVER 7.
But is this really possible? Would it be save to upgrade like this?
Has anyone got some experience with this?

Regards,
Falco

2. Inefficient IN clause?

3. SQL Server Chat: SQL Server 2000 OLAP: Designing and Optimizing Analysis Services Cubes

4. odbc vs oledb

5. From Sql Server 7.0 Olap to Sql Server 2000

6. Connecting to Progress/400 Data Server over Mcrosoft SNA Server

7. Whats the best way to move a SQL 7 database to SQL 2000 on another server

8. Help: Can we alter session for other sessions

9. What is the best way to migrate a SQL 7 to SQL 2000 on another machine

10. best way to upgrade sql 7 db to sql 2000

11. MS SQL 2000 - Clustering w/OLAP

12. SQL Server 2000 / OLAP

13. SQL Server 2000 OLAP Analysis Service Problem


All times are UTC
Board index