Hi

I thinking of getting
Microsoft SQL Server Work group Edition 2000 + 5 Clients, English, CD

Does this support Indexed views - I seem to think I saw this
restriction but cannot find it now..

Thanks

i thought that only enterprise edition supports it

and developer's of course

i personally think that workgroup is a scam; i mean-- what's the point
of having SQL without having Olap?

i'd rather use mySql

-Aaron

Because is much cheaper - if you want a proper RDMS. I don't use OLAP
or analysis tools.

mySQL - I tried v.disullusioned with. I downloaded the latest version
at the time and they introduced a performance problem - it went 8 times
slower on a windows box when the DB was on a win server and the client
on a windows client - compared to the previous version. What really
shocked me - this was a serious bug for them but not critical. I
dropped it after this - I mean this is critical..

Just my opinion - mysql you could tell it was many developers working
on it - but not too well coordinated.

For example

select fname, lname, count(fname)
from mytable
group by fname

SHOULD NOT WORK - i.e. what lname should you choose? - any DB Sybase,
Access Oracle will complain. MySQL runs the query and just selects a
lname value at random.

how yeah i worked on sybase; it was quite similiar to SQL Server 4.2 i
believe..

and it would just hang forever-- running off in lalaland if you didn't
fill in the group bys correctly

i was working for a stock exchange; it was kinda surprising that they
didnt see the major problem with that either lol
friggin kids fired me for using the COALESCE function instead of
isnull-- it's like-- i was using it on measures not members; it's not
like the measures are indexed anyways so who cares, right?

-Aaron