Horst / Peter, For the sake of other members on the list, I hope we can finish this discussion shortly. I have attached some extracts from the Help file, showing how to setup the following, and in Microsoft's usual fashion, you may need the more expensive "Enterprise Edition" to utilise SOME of these advanced features:
1/ Replication without add-ons. And explaining the different models and strategies. 2/ "Real" Hot Backups, using a feature called Log Shipping (sorry I am missing the drawing, but I can get more detail for you)- without Add-ons. It also supports "High Availability" with Failover Clustering. Typically Active-Passive. 3/ And a bit of detail on "Checkpoints" which details how transaction logging works. There is more detail on this in the Manual, which I can send if you wish. Postgres refers to this concept as Write-Ahead Logging in their manual. Boolean data type is just that using JET, but as you quite rightly point out in Native SQL 2000 they have a data type called "Bit" which is effectively the same, but may not be SQL92 compliant. Relevance ?????? Depends I guess, some might have an issue with that. Standards ?? I see your point. Sorry for pulling you up this Horst, but most of the time, I'm not bothered too much when people express an opinion on something. They're entitled to do that. But when we see a mistake, we owe it to each other to correct it. For the members of the list. Regards Barry Lollo Townsville Division P.S. I missed catching up with you on your Magnetic Island trip..maybe next time !! :) > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Horst Herb > Sent: Friday, 3 February 2006 5:13 PM > To: General Practice Computing Group Talk > Subject: Re: [GPCG_TALK] What The !! > > 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_manage > ment_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 >
SQL Details.rtf
Description: SQL Details.rtf
_______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
