Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 2,443 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/29/2009)


    GilaMonster (4/29/2009)


    Bruce W Cassidy (4/29/2009)


    [font="Verdana"]International Star Wars day... "May the 4th be with you."[/font]

    *groan*

    Hmmm, we were discussing having another Starwars day.....

    Now for something totally the same...

    How many...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

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

    rboggess (4/29/2009)


    Why does it seem that everything is three to five times harder to do in Oracle than it is in SQL Server?

    Simple math, looks like you've just...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    And now for something completely different -

    I don't know if anybody else caught the new blockbuster radio commercial where Yoda urges somebody to do - not try - their...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/29/2009)


    And the secret ingredient is . . . . you have to use a cursor!

    jc 🙂

    I'm so happy someone else has seen that show. I loved...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    GilaMonster (4/25/2009)


    WayneS (4/25/2009)


    2. For the slowness of the reports, he was copying the tables needed for a specific report to a temp table (he did not add any indexes to...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/23/2009)


    My topic would more likely be... Laughable SQL

    Other contenders:

    Sensual SQL (potential best seller title here, Jeff take note)

    Cooking with SQL

    Why isn't there an SQL equivalent to Iron Chef?...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Insert Commas Into Number String

    Nice trick, swallow!

    African or European?

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: datetime - 1/1/1900 treated as blank??

    Crazy. Wonder what those folks would think if they knew their birthdate was causing issues in your fancy database and you went to the internet to help resolve it?

    🙂

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: datetime - 1/1/1900 treated as blank??

    curious - what functionality are you adding in that needs to see 1/1/1900 as a valid date?

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/18/2009)


    you can't have a war if no one shows up.

    That just means you won.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Reverse string without built in functions

    GSquared (4/20/2009)


    That's not part of the addition. That's just setting up a framework to run it. Run the query without that, with the numbers directly in the Where...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Gaby Abed (4/17/2009)


    Derek Dongray (4/17/2009)


    David Burrows (4/17/2009)


    To Thread or not to Thread, that is the question;

    Whether 'tis nobler in the mind to suffer

    The angst and flames of outrageous posters,

    Or to...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/17/2009)


    Chris Morris (4/17/2009)


    RBarryYoung (4/16/2009)


    john.arnott (4/16/2009)


    Am I so obsessed with big round numbers that I would ...

    Coincidentally, that's also how I got my first date... :w00t:

    C'mon Barry ya can't...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Reverse string without built in functions

    GSquared (4/16/2009)


    Michael Valentine Jones (4/15/2009)


    Maybe you should learn to use what is available in SQL Server, like REVERSE, instead of spending time duplicating what is already available.

    Nah. One of...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Introduction to Profiler

    Very nice article Jack, I would be in the crowd who needs this introduction, and found your article to be very well written and easy to follow.

    Looking forward to...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 2,071 through 2,085 (of 2,443 total)