James Goodwin (7/14/2010)

---

I think the moral of the story is: What the requirements say the customer needs, and what the customer says that they need and what the customer...

Yes Mike, I was. Such a profound concept, a whole school of philosophy, from those magical six words, from a man you would never think of.

Funny that someone mentioned typewriters,...

To answer some critics: yes, we could have done a lot of tuning. It was a development database that was being played with daily, the DBA was famously lazy, there...

I have a different, I think better definition of master data. To me, master data is the result of high value transactions. For example, if Starbucks messes up a coffee...

Here's a better way:

SELECT 'IN A NOT B' location, a, b, c, d, ...

FROM tablea

EXCEPT

SELECT 'IN A NOT B' location, a, b, c, d, ...

FROM tableb

UNION ALL

SELECT 'IN B NOT...

OK, I see, it's real worth comes in DBA type optimizations.

However G, you do make the following point:

"In the real world, SSAS doesn't get anywhere near the use that it's...

The article was well written and funny, but I do have one beef with it. It lacked the qualifier "When execution speed is more important than anything." Since cursors tend...

Sure, in Unix it does. I meant lexically, like in human languages.

If you're putting Unix commands into the data, then yes, you'd have to find something else. I don't think...

Klaar Chris, klaar. My point of view exactly.

In English "mark up" is something you do to documents, not databases.

"If I understand you correctly, you are suggesting that I could create a delimited text file, but instead of using a comma, I could use the grave character? "

Yes.

"Or maybe...

"BUT how would you solve the following problem without XML?

............You have to send data to another agency. The data is not only completely outside your domain, but will be...

"Is there an Object-oriented database that persists methods within each object? (loaded question)"

Yes. Oracle.

"The alternative to an XML schema would be either:

1) flatfile definitions with a shelf full of written...

I've had in mind to write an article on the proper uses of XML languages: to mark up text. They are very good at things like DocBook, etc., where you...

I wrote an article on this very subject a while back:

http://www.sqlservercentral.com/columnists/shirsch/whatisxml.asp

It hasn't been 4 years, it's been 10 years since XML was created.

Among the myriad problems with using XML languages,...

It's what I call the "technology of the future" that will always remain so. It's mostly just used for trivial purposes.