Jeff Moden (1/17/2009)

---

Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen where...

The Execution Plans, as reported, contain a lot of stuff and we are really talking about 2 different things in them. You are talking about the cost estimates and...

Heh, I did say "likely", Jeff. 🙂

Hey, I just read it. That is a great article!

Jeff Moden (1/17/2009)

---

Actually, Sushilla (Sue) did one a couple of years back. It was so well written that I came within a couple of milli-seconds of putting a plug...

This site, here, has a tremendous amount of resources to help you evaluate this and to help Oracle professionals understand the difference between Oracle and SQL Server.

For those who may care, the formal study of numerical approximations and error in calculations is called "Numerical Analysis". It's a course that Math & CompSci majors should take...

Yeah, that rings true. I am recalling now, that most of these instances seem to be cases of insufficient data that attempts to infer some missing grouping factor by...

Jeff: do you have any pointers to some of these prior examples? I seem to recall that I understood their reasoning when I read them, but I cannot remember...

Jeff Moden (1/16/2009)

---

I don't believe they...

There is a free tool: the "SQL Server Migration Assistant" (SSMA) from Microsoft that can do much of the conversions for you, and guide you through the process.

Also...

You can do the computations in a SELECT statement, you just cannot assign to both variables and columns in a select statement.

Shame too.

Hmmm, that makes it sound like it is a quote doubling problem ...

Scott T (1/16/2009)

---

--With simple calculation we don't care about data-type (float or decimal)

--====================================

--When we start calculation like the following one, we should use decimal

-- Let's see example

...

--=====================

As you can see...

Jeff Moden (1/16/2009)

---

RBarryYoung (1/16/2009)

---

It's weird actually. There's no obvious reason why RANK() and ROW_NUMBER() should be faster than MIN(), but they clearly are when you look at the differences...