Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 2,443 total)

  • RE: Join vs Where

    From that perspective then, no I don't believe that there is a difference.

    SELECT myTable.myColumn, yourTable.yourColumn

    FROM myTable, yourTable

    WHERE myTable.myColumn=yourTable.yourColumn

    should be treated the same as

    SELECT myTable.myColumn, yourTable.yourColumn

    FROM myTable

    ...

    ---------------------------------------------------------
    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?

    Just saw this, somewhat relevant, although not related to the 'hot news' aspect of it: http://arstechnica.com/web/news/2010/04/dont-publish-dow-jones-hits-briefing-service-with-hot-news-lawsuit.ars?utm_source=rss&utm_medium=rss&utm_campaign=rss

    ---------------------------------------------------------
    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?

    CirquedeSQLeil (4/22/2010)


    jcrawf02 (4/22/2010)


    woohoo! Brent's coming to cowtown!

    What is twapperkeeper?

    I'm sure it is supposed to bring back memories of the Trapper Keeper (how many here had one of those?).

    Loved my Trapper...

    ---------------------------------------------------------
    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?

    woohoo! Brent's coming to cowtown!

    ---------------------------------------------------------
    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?

    The Dixie Flatline (4/22/2010)


    Dandelions. Hard radiation.... it will either kill them or mutate them to the point that they kill you.

    You would suggest that 😛

    ---------------------------------------------------------
    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?

    GSquared (4/22/2010)


    Clorine triflouride

    It's hypergolic with just about everything.

    That's the one I was thinking of that you mentioned previously. The wikipedia entry is equal parts scary and hilarious, especially the quote...

    ---------------------------------------------------------
    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?

    Tom.Thomson (4/22/2010)


    jcrawf02 (4/21/2010)


    Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

    And now for something completely different...

    Any advice on ridding my lawn 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: Today's Random Word!

    Chris Morris-439714 (4/22/2010)


    jcrawf02 (4/22/2010)


    Chris Morris-439714 (4/22/2010)


    jcrawf02 (4/21/2010)


    Taraxacum

    Salad

    Dressing?

    Undressing - see water cooler thread 😉

    ack! TMI...

    ---------------------------------------------------------
    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?

    Grant Fritchey (4/22/2010)


    jcrawf02 (4/21/2010)


    Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

    And now for something completely different...

    Any advice on ridding my lawn...

    ---------------------------------------------------------
    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: A DBA's Daily routine (and other items...)

    So what would you do if everything died? Fix what you know of and wait for the users to yell about whatever you didn't know of?

    Anyway, if it's not...

    ---------------------------------------------------------
    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: Today's Random Word!

    Chris Morris-439714 (4/22/2010)


    jcrawf02 (4/21/2010)


    Taraxacum

    Salad

    Dressing?

    ---------------------------------------------------------
    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: SQL Syntax

    I'll second (third?) the sentiment of Lynn and Jeff, from the perspective of a non-expert, if you post the code, you're taking advantage of their experience and brain-power, and they...

    ---------------------------------------------------------
    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: Join vs Where

    I would follow up Jason's point with a simple question (once you understand more about the different kinds of joins):

    How do you replicate a LEFT JOIN using 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: Advantage of Using Constraint when adding FK or PK

    Shot in the dark, but I feel lucky. :hehe:

    ANSI standard?

    ---------------------------------------------------------
    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: A DBA's Daily routine (and other items...)

    GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are barely touched,...

    ---------------------------------------------------------
    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 - 1,381 through 1,395 (of 2,443 total)