I dont understand the nuances of databases. All I know is that MS-SQL
cost a fair bit but has been stable, plays nicely with our Windows
environment and our computer chap can maintain it easily and
inexpensively. (and it does hot backups)
Duncan
Barry Lollo wrote:
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
------------------------------------------------------------------------
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
