Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 14,953 total)

  • RE: Why blocking issue resolves by UPDATE STATISTICS?

    Don't know if it's a bug, or if some piece of it was "runnable", while other pieces were "running", and it showed as "runnable" because of that.

  • RE: Hierarchical Query to Return All Children

    dwain.c (7/23/2012)


    GSquared (7/19/2012)


    Jeff Moden (7/17/2012)


    GSquared (7/17/2012)


    He was talking about the last solution I posted. That's a while-loop version.

    First, apologies for not responding sooner. I've actually be working on...

  • RE: Time Zones

    Russell:

    On the point of "midnight on <date>", it's another ambiguous term that really has no meaning. If one considers the moment of midnight to be both days (most common...

  • RE: Time Zones

    jbnv (7/20/2012)


    Russell Lavelle-langham (7/20/2012)


    at the risk of starting a whole new thread fork, it's Beer O'Clock here in London, England so I'm off out to play.

    That is one definite problem...

  • RE: Time Zones

    jbnv (7/20/2012)


    Russell Lavelle-langham (7/20/2012)


    at the risk of starting a whole new thread fork, it's Beer O'Clock here in London, England so I'm off out to play.

    That is one definite problem...

  • RE: Stack Ranking

    Michael Valentine Jones (7/20/2012)


    Harsh ranking systems are very common in sales.

    Someone told me about an automobile dealer he worked for where every month they started with 13 salesmen and at...

  • RE: How to find out total number of immediate children of a parent in HierarchyID

    With HierarchyID datatype, you can use the GetAncestor() method to find all rows that have a given ancestor at a given level.

    If, for example, you want to find all rows...

  • RE: Stack Ranking

    If the stack ranks were understood to be a bell curve with a flexible median, it would work as a system. In other words, you may rate a person...

  • RE: T-SQL transactions to complete two functions

    You're welcome.

  • RE: Time Zones

    Chris.C-977504 (7/20/2012)


    Alex Fekken (7/19/2012)


    By the way, the metric system [advantage is] you keep using the same unit name (with a prefix) when you scale up or down. It is a...

  • RE: Time Zones

    Tao Klerks (7/19/2012)


    djackson 22568 (7/19/2012)


    I also appreciate that someone else is willing to point out there is no 12:00 AM or PM!

    OK, I didn't understand the reference the first time,...

  • RE: Time Zones

    Tao Klerks (7/19/2012)


    GSquared (7/19/2012)


    Both systems are fully arbitrary. One just has a more generic unit-conversion nomenclature is all. Metric (not SI) recently had to modify its definition of...

  • RE: Time Zones

    Tao Klerks (7/19/2012)


    GSquared (7/19/2012)


    Tao Klerks (7/19/2012)


    Lynn Pettis (7/19/2012)


    Two, on this "The Imperial system works; the metric system works better", whose definition of better? What makes it better? Or...

  • RE: Time Zones

    paul.knibbs (7/20/2012)


    Steve Jones - SSC Editor (7/19/2012)

    I'll trade you this for making everyone drive on the right side of the road :w00t:

    But if we did that, how would we keep...

  • RE: Error: Unable to switch encoding

    Okay. Looks like you have a character in the XML that doesn't fit within that encoding. It's pretty limited, so if the file has anything like some of...

Viewing 15 posts - 1,186 through 1,200 (of 14,953 total)