Re: MS SQL Server - a plethora of limitations...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mario Splivalo (majk_at_fly.srk.fer.hr)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 12:55:43 +0000 (UTC)

On 2004-06-10, Joe Celko <jcelko212@earthlink.net> wrote:
>>> Here's a few reasons why I feel MS SQL Server is still a load of
> crap, and will never be many developers RDBMS of choice <<
>
> Most of your objections are that MS-SQL is not Oracle. Well, Oracle
> sucks rocks -- those lying idiots cannot even get the basic data types
> correct -- and fails to follow standards even worse that SQL Server.

May I ask for some pointers to this, maybe a web link, or something? I've
never been using Oracle, I have some experience with Informix, but the guy
at my company (he's a Java developer using SuSE linux) says that only
PostgresSQL and Oracle are true RDBMS. I have spent my time building both
MySQL and PostgresSQL systems (mainly for some idiotic web portals), since I
'moved' to MSSQL it feels like driving in a fine limo. This guy keeps saying
that only Oracle follows the standard, and all of that, so, I'd realy like
to give him some links to keep him quiet for a while.

>>> 22 No repeat until - (post predicate loops), while loops can perform
> this but one extra check often has to be performed <<
>
> Big deal. First of all, good SQL programmers do not use loops. And
> again, remember that T-SQL is not an application development language.

And, repeat-untill just adds confusion. Good programmer will choose a
standard, and keep to it standard. I hate to see (and I'm speaking about C
now) people test extits from loops at the begining, then in the middle, then
at the end, with no particular reason. I've read that research show that
while loops with exit test on the begining is much easier to understand from
the first reading.

        Mike 

-- 
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@jagor.srce.hr

Relevant Pages

  • Re: hierarchical query - returning a treewalked subset
    ... pretty small), and if a row is LEVEL 1, it loops thru the resultset ... Take any query that produces a result set in Oracle. ... only for system account ... 100 torrent files; ...
    (comp.databases.oracle.server)
  • Re: an old worn interview question
    ... directed graph. ... easily loops can arise. ... This query will search a table for all the rows sharing a common ... then Oracle returns an error. ...
    (comp.programming)
  • Re: Cursor for loops
    ... No, no, I didn't mean simply 'for loops', but 'cursor for loops'. ... They look like this in Oracle: ... FOR mycursor IN ...
    (microsoft.public.sqlserver.programming)
  • Re: Cursor for loops
    ... No, no, I didn't mean simply 'for loops', but 'cursor for loops'. ... They look like this in Oracle: ... FOR mycursor IN ...
    (microsoft.public.sqlserver.clients)
  • Re: Cursor for loops
    ... No, no, I didn't mean simply 'for loops', but 'cursor for loops'. ... They look like this in Oracle: ... FOR mycursor IN ...
    (microsoft.public.sqlserver.server)