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.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: T-SQL transactions to complete two functions

    You're welcome.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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