Forum Replies Created

Viewing 15 posts - 16 through 30 (of 72 total)

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    No, problem. I don't know why Jeff wasn't able to get it, unless they could sense who he is and realized he is so good that he doesn't need...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Jeff Moden (5/15/2008)


    Looks interesting... can't download the code, though, because I'm not a member and they want too much info for my liking.

    Jeff, I was able to download the code...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Getting Organized

    John Magnabosco (5/6/2008)


    How do you eat an elephant? - One bite at a time.

    Your strategy of breaking large, long-term tasks into smaller tasks is exactly the way to go.

    I also...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Query to get all days of a specific month and year

    Jeff,

    I have seen you use a tally table way too many times (this is not a bad thing ;)). When I saw the title to this post, even...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Jeff,

    As always an excellent, excellent article!:smooooth: I have always seen you use the tally table in your posts and you usually explain it, but this article provided me the...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Should I Buy a Kindle?

    I do like the ability to search in an e-book, but mostly for some technical books. I would probably still like to have a physical copy as well. ...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: A Function Gotcha with the Use of an Asterisk

    Great article! I too avoid using SELECT * unless I am using it during testing and will not put it in production. A lot of the legacy code...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: The April Energy Update

    Robert Hermsen (4/24/2008)


    The other HUGE issue is that we as humans and especially americans have lost a very important ability. Survival.

    So the power is out. Who cares. ...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Padding function

    Good article. I appreciate the way you put a parameter list at the top of the article as well as in the function itself. This made it easier...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Adding/updating rows of data that is missing but not in sequential order

    Matt, GSquared,

    Thanks for the info. The version on the this site is simple and has some nice options. I always love the fact that in our industry, if...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Adding/updating rows of data that is missing but not in sequential order

    Jeff Moden (4/12/2008)


    As you're finding out, the hard part is to "smear" the existing data into the new rows for the missing years. This type of smearing is VERY...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: SQLserver.com clock wrong?

    Matt Miller (4/8/2008)


    All I want to know is - who do I call to get that hour of sleep back....?

    Matt - I think there is going to be a CU...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Inside The Question of the Day

    First of all, I want to applaud Steve on everything he does for this site. Little by little, we understand what he does and I am always impressed. ...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: Virtualization for Database Development

    Grant - good article. The timing is ironic - last night at my local developer group, we were given presentations on virtual machines. They mostly talked about virtual...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

  • RE: What kind of DBA are you?

    Bob Fazio (4/10/2008)


    DonaldW (4/10/2008)


    Yes. That is my daughter. And...

    Ian.

    "If you are going through hell, keep going."
    -- Winston Churchill

Viewing 15 posts - 16 through 30 (of 72 total)