Interesting technique. Thanks.

I am curious, though, about why you chagned the formula from (P(t) - P(t-1))/P(t-1) to

(P(t+1) - P(t))/P(t). I realize it amounts to the same thing in...

Well, sod it! I hope MS does something about that soon.

Thanks for the info, all the same

Richard

I can't say I have noticed any sluggish behaviour; SSMS behaves just fine for the most part, it's just the initial load of data by the activity monitor that takes...

Yes! It has been this way since we installed. It refreshes quickly enough; it's just the initial data load that's slow. We run a cluster and I...

Tom.Thomson (4/5/2010)

---

Ed-997158 (4/5/2010)

---

I found "The world will come to an end, but music and love will endure" as the translation for your second tag line, but might I request a...

I'm probably stirring up a hornet's nest here but I have a problem with the way you are treating nulls. The whole point of null is that the value...

Ah! Good catch on Oracle vs Sql Server; I didn't realize it was that obvious:-).

Thanks for the explanation; it makes more sense than what I was imagining.

Richard

I find the variable assignment rather interesting in that it seems to occur at a curious point. To see what happened when there is a null value, I tried:

declare...

Charles Kincaid (10/7/2009)

FROM sysobjects

INNER JOIN syscolumns ON sysobjects.id = syscolumns.id

INNER JOIN systypes ON syscolumns.xusertype = systypes.xusertype

The querry is against sysobjects to get information to get information from...

Thanks for a lucid article. I'm from the "old school" so this cemented what I had picked up ad hoc.

I have a quick question however. I have, not...