Grant Fritchey (5/6/2009)

---

It really depends on the business requirements. But if you're dealing with hard numbers, I'd use decimal instead of float. Float is an approximate number. This is from...

It'll depend on the columns and their indexes and stats.

Update and select don't necessarily end up with the same plan. For that matter, the same select can end up with different plans sometimes, under the right circumstances.

Something you...

I don't think it's all that many years away. Prices are coming down like crazy, and capacity and speed and reliability are way up every year.

I wouldn't be surprised...

There are a couple of easy ways to get simple basics in T-SQL.

One would be get a For Dummies book, or something like that.

Another would be look stuff up in...

Are you asking how to enable it? Just not sure what your question is at this point.

Not sure what you mean.

True on the "is null" thing. That's an important one.

On the sub-query, it sounds like you may have come up with the classic "triangular join" that gives running total...

How fundamental is fundamental? Are you looking for a few practical basics, or for the underlying theory and the set-based math of that, or for a few definitions, or...

dmc (5/5/2009)

---

There is nothing worse than a set based operation on millions upon millions of rows, especially when it hits an error and spends just as much time rolling back...

You're almost certainly going to be better off looking for .NET versions, and plugging them in as CLR functions.

In SQL 2000, you pretty much have to do this in steps. Select the top 4, then select the top 2 of that but with reversed ordering, then select...

dmc (5/5/2009)

---

Agreed. I guess its difficult to say what to do unless you are intimate to the situation. Maybe the code is as simple as some deletes and uses...

If you provide a sample of the output you're looking for, we can probably help you get there.

Reviewing the code does make some sense. You might be able to make something more efficient.

But if the proc does what's needed, why not just use it as-is? ...