Viewing 10 posts - 1 through 10 (of 10 total)
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...
October 18, 2011 at 9:14 am
Well, sod it! I hope MS does something about that soon.
Thanks for the info, all the same
July 22, 2011 at 8:13 am
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...
July 21, 2011 at 9:30 am
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...
July 18, 2011 at 5:01 pm
June 4, 2010 at 11:57 am
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...
January 27, 2010 at 9:13 am
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.
December 14, 2009 at 1:58 pm
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:
December 14, 2009 at 1:17 pm
Charles Kincaid (10/7/2009)
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...
October 7, 2009 at 11:33 am
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...
October 7, 2009 at 10:25 am