On Fri, 3 Feb 2006 15:32, Barry Lollo wrote: > I knew you'd be in there with a comment. And as I suspected....the > religious zealot's could not contain themselves.!!
Suppose science and religion don't mix,and that would exclude the "religious zealot" attribute for me. Religion is the domain of the irrational (like the choice of MS SQL ;-) ) > However the following statement is just wrong. Is it? Doubt it very much. See my comments below. > > "Time has moved on though in the database scene in the past 15 years. > Features like hot backup, replication, more standard compliant SQL > implementations, "native" spatial data types, user defined data types, > externally linkable stored procedures, write-ahead logging, point in > time recovery features etc., have become standard in all serious > contenders - but not in MS SQL server." > > Every single one of these features is available today on SQL 2000, and I > am just not up-to-date with SQL 2005, but I can only suggest it is > better then SQL 2000. Not spatial data (at least no index support for it): http://en.wikipedia.org/wiki/Comparison_of_SQL_database_management_systems MS-SQL doesn't even have a boolean data type (at least in version 8.0) which is required by the SQL-92 standard! Neither does it have any native time / date interval data types, nor can it index any of such data types if constructed by other means You can't group query results by alias nor by position You can't even do natural joins! How do you do replication without add ons? Real hot backups still only achievable with add on tools (correct me if I am wrong) Where is the write-ahead logging? > You should have sat on one of my courses Horst....I suspect you have not > been using MS SQL for well maybe 15 years or so !! Even you may have > learnt something. For 8 years actually I haven't used it. Prior to that, I was administrating the MS SQL database for the hospital I was working as a surgeon after their full time DBA quit and they couldn't get a replacement for love nor money. But I still read the relevant DBA literature, and I still exchange emails with one of the original Sybase developers (I was a Sybase DBA at the Technical University of Munich more than 15 years ago) Horst _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
