Re: What is it with you Joe Celko take 2

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

All you ever write about is what everyone else does wrong. <<

Actually, I have eight books, 800+ articles and dozens of
presentations on how to do it right :)

LMAO!! There is a recent thread called "date question" where I am
eventually being compared to you. This is really funny! I'm encouraged
to read some of your materials now. Can you please offer me the name
of one of your many books that is geared for high performance ...
possibly to include extended stored procedures and hopefully sqlncli
from a C perspective with an interest in bcp?

I have a personal request. Can you please review that topic and see
how "CELKO" I am being? It must be nice to have your name be that
adjective for something.

Now SQL Server is a good product but out of all the products I use I would have to say it has the most outdated feel of any of them. <<

I am not sure what that means; it feels like a Windows product, which
is no surprise.

It has more "gotchas" than anything I've ever used .. <<

LOL! Wait until you get to Oracle. You will get dialect, 300+
configuration parameters, etc.

and it's quite amazing some of the silly work arounds that are required. <<

My gripes would be the parts that are still missing compared to DB2,
Oracle, Mimer and other SQLs. I want a ROWS clause in OVER(), the
redudnant proprietary stuff dropped and T-SQL replaced with SQL/PSM.
Also, it does not run on enough platforms. But it keeps getting
better. And I can make it work

Oh, if you know how to make it work with Wine you must share.

Do any of those other platforms allow you to create functions in C/C++
and have them added to the primary language? Extended stored procs
have their limits and being able to truly extend the the t-sql
function list would be good.

As an example, we can finally write our own custom aggregates (wow, a function that add up stuff in a list) but it's so kludgy we can't even pass in extra parameters to it and you recommend we don't use it anyway. <<

Your problem is that you just don't get it. SQL is a data retrival
and integrity tool. PERIOD. Repeat the word DATA several times. It
is not a computational language. It is not an application development
language like COBOL. It does not handle lists like LISP. It cannot
handle strings like ICON. It has nowhere near statistical power of
SAS.

amen.

We don't want to write aggregate PROCEDURES -- repeat the word
PROCEDURE several times, so you will remember that SQL is
declarative. We want to write queries and constraints. PERIOD. In
fact the joke inside X3H2 was that SQL stood for "Scarily Qualifies as
a Language" because it has no I/O of its own, minimal math & string
stuff, etc.

i hear ya.

You can force it and kludge it to do other stuff, but it is bad
progamming. Ever see "Comercial FORTRAN" packages? We did COBOL-
style math in Fortran character arrays. That is as bad as doing bit
fiddling in SQL for the same reason. In the words of Mark Twian, you
are cussing the pumpkin for being a bad shade tree.

If taken as a system to hold and retrieve data with an atomic nature
for multiple users, do you recommend MSSQL? If not then what?

If you needed a multi-user system for data storage and retrieval for
high performance, what might you recommend?

.

Relevant Pages

  • Re: Stored procedure returns duplicates
    ... This is a COBOL program written in SQL! ... you are writing COBOL in SQL and want strings! ... You write SQL with flags like it was 1950's Assembly language! ...
    (comp.databases.ms-sqlserver)
  • Re: How to interact with Oracle, MS-SQL and Sybase databases using C Language
    ... Please provide me information about links or books which discuss this subject ... SQL. ... A simple google search on either of those terms will give you the information you need. ... Learn to program using Linux assembly language ...
    (comp.lang.c)
  • Re: Full-Text Catalog does not build...
    ... You're welcome, Oleg, ... I've not confirmed if the Arabic language will be a FTS supported ... language in SQL Server 2005, you may want to review the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL
    ... Language can and do this. ... SQL is typed, ... How about something from the domain of custom biz apps. ... yet nobody would even try to use RDBMS for that. ...
    (comp.object)
  • Re: Databases as objects
    ... Isn't SQL able to assimilate to business vocabulary? ... using the same domain-ignorant language? ... Isn't the database schema already a domain-specific interface? ... have lesser lines of code than a corresponding assembler source code. ...
    (comp.object)