Forum Replies Created

Viewing 15 posts - 31 through 45 (of 72 total)

  • RE: Gotcha! SQL Aggregate Functions and NULL

    Mike,

    Another great article - I have added this to my "briefcase." This gave me good information that I didn't know about these functions. The way you organized the...

    Ian.

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

  • RE: Bachelors degree - Who has one, or even more education?

    Steve Jones - Editor (4/4/2008)


    I have 2 years of Comp Sci from the mid-80s, when we used Big Iron, VMS, central printing, timesharing, etc. We worked on VMs inside there,...

    Ian.

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

  • RE: Auto Restart SQL-Server Agent

    SQL ORACLE (4/7/2008)


    By default, BUILTIN\Adminstrators, has sa role.

    Thanks. That is what is set (along with a few others) on the server I have problems getting this to work. ...

    Ian.

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

  • RE: The March Car Update

    My wife and I had 2 primary reasons why we got a Prius recently - 1. My previous car died and it would have cost more then it was worth...

    Ian.

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

  • RE: Auto Restart SQL-Server Agent

    Balakrishnan.K,

    Have you had any success getting this fixed? I have the exact problem on one of my servers. I have made a few changes per the others posts...

    Ian.

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

  • RE: SQL Server 2005 Adoption Survey Results

    I wonder how much the numbers would change if the survey was conducted now (a year later). Also, would the delay in the release of SS 2008 make any...

    Ian.

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

  • RE: Four Rules for NULLs

    Mike C (4/1/2008)


    No problem, and thanks (big Family Guy fan here) 🙂

    This is an oversimplification (no flames please), but I suppose you could think of it like this: replacing...

    Ian.

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

  • RE: Four Rules for NULLs

    timothyawiseman (3/31/2008)


    I know this is an old article, but this is the first time I read it, and it is the best written piece explaining nulls I have seen yet....

    Ian.

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

  • RE: Social Software

    Steve - Yes, I did mean with the editorials. On that note, I always get something out of the editorials (even if it is different viewpoints on your rants...

    Ian.

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

  • RE: Social Software

    I too, for the most part spend a majority of my time viewing articles and reading many of the forum discussions. I have been able to post a few...

    Ian.

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

  • RE: Generate subtotal and grandtotal records

    Jeff Moden (3/4/2008)


    I suspect it would be a little cumbersome to implement

    Heh... you got a problem with {ctrl-c}{ctrl-v}???

    Not at all - well maybe only when I cut and paste

    and...

    Ian.

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

  • RE: Generate subtotal and grandtotal records

    Thanks for your input everyone.

    Lynn Pettis (3/3/2008)


    Time to ask a question, why the sub-total every 5 records? Seems to me this should probably be done on the application side,...

    Ian.

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

  • RE: Generate subtotal and grandtotal records

    ROLLUP is definitely on the right track to what I want, however it is not 100% there. Unless I am missing something, I don't see a way to ROLLUP...

    Ian.

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

  • RE: Sequential numbering issue

    Matt Miller (2/28/2008)


    Maybe make it part of your signature? Crude but effective.....

    I am surprised he hasn't included the link to his article on Forum Etiquette in his signature block.;)

    Ian.

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

  • RE: Sequential numbering issue

    Jeff Moden (2/27/2008)


    Yep... I'm aware of that, but thanks for making sure, Ian.

    So far as using spt_Values as a source of numbers in production, I NEVER do it... I always...

    Ian.

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

Viewing 15 posts - 31 through 45 (of 72 total)