Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Calculating Stock Returns Using the ROW_NUMBER function and CTEs

    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...

  • RE: SQL Server 2008 R2 Activity Monitor

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

    Thanks for the info, all the same


  • RE: SQL Server 2008 R2 Activity Monitor

    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...

  • RE: SQL Server 2008 R2 Activity Monitor

    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...

  • RE: Expanding The Scope of Bridge Tables

    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...

  • RE: Get Your ANSI_NULLs Settings Consistent

    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...

  • RE: SELECT @local_variable

    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.


  • RE: SELECT @local_variable

    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:


  • RE: SQL & the JOIN Operator

    Charles Kincaid (10/7/2009)

    FROM sysobjects

    INNER JOIN syscolumns ON =

    INNER JOIN systypes ON syscolumns.xusertype = systypes.xusertype

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

  • RE: SQL & the JOIN Operator

    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...

Viewing 10 posts - 1 through 10 (of 10 total)