Sergiy (10/29/2007)

---

rog pike,

Itzik Ben-Gan and Sujata Mehta

OVER Clause and Ordered Calculations

http://www.insidetsql.com/OVER_Clause_and_Ordered_Calculations.doc

is horrible.

They should learn T-SQL first, before they write long articles.

As I said:

OVER() is useful for those who does not...

This was/is an interesting thread. But I would suggest before

diving into comparisons of elapsed time people would get as

broad a view as possible of the objects of their exercises. And

that...

>No doubt... RAC does everything...

>

>... slower...

>

>I already have enough performance impinged tools... but thanks

>anyway. You still haven't answered my question, though... how

>long does the million row example take?

Jeff,

The...

>I tested my cursor version against this on a million rows

>TESTING TESTING TESTING....did someone mention testing?

(This is not directed at anyone in particular. At most it

rises to...

Just curious... how long does it take RAC to do the million row test to accomplish the same thing? I'm not talking about development time, I'm talking about execution...

Jeff,

If I was really mean I would make RAC open source 🙂

You could try to duplicate some functionality. Who knows you may come up with some good techniques. Then...

DCPeterson (9/25/2007)

---

I'm late to the discussion, but here's my cynical two cents anyway...

It will never happen..

Well it 'has' happened to a significant degree. The product is called Dataphor @

[url=http://www.alphora.com/...

Jeff,

By your training, your education, your professional work, your use of MS technologies, in fact everything in IT today still revolves around the historical client-server model in one way or...

When tables are 'variables' you can create what I called

a 'Super Function'. Pass any table of the appropriate 'type'

to the function, it's that simple. The example was a function

that returned...

Jeff,

When tables are 'variables' you can create what I called

a 'Super Function'. Pass any table of the appropriate 'type'

to the function, it's that simple. The example was a function

that returned...

Steve,

Who do I talk to for a presentation. I can think, speak and write and I have quite interesting things to talk about. If these traits don't disqualify me for...

Jacob, Wayne, Charles and other interested parties,

There is the sql standard and then there is the 'relational' approach. I urge you to compare S2008 MATCH with the ideas presented here:

Jeff,

Disclaimer - this post has *nothing* to do with RAC

It really is quite simple in the arena of application development.

The meaning of a...

Eric Wilson writes:

>Why not ASK MICROSOFT and other DBMS vendors to build in Table-Vars as

>fully fledged things?! Why are we stuck with XML work-arounds

>(which I too use) when a relational...

Jeff,

If your going to swiftboat me the least you should do is be specific.

What exactly are you referring to that doesn't work.?

Fish or cut bait.