Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (9/25/2013)

    Jack Corbett (9/25/2013)

    GilaMonster (9/25/2013)

    Someone want to add a voice of reason to this?

    http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx

    I'd try but that tempDB thread has worn me out.

    Indeed. Though it's good to know...

    September 25, 2013 at 6:20 pm

    #1653388

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (9/25/2013)

    wolfkillj (9/25/2013)

    What's the terminal velocity of a potato?

    European or African?

    Unladen or laden with butter, sour cream, bacon bits, etc.?

    Surely there's no such thing as European potato?...

    September 25, 2013 at 2:41 pm

    #1653353

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (9/25/2013)

    Jeff Moden (9/25/2013)

    I forgot to mention a feature of the original that I made. I had beveled the muzzle so that it would cut the potato to...

    September 25, 2013 at 9:11 am

    #1653227

  • RE: Are the posted questions getting worse?

    wolfkillj (9/25/2013)

    paul.knibbs (9/25/2013)

    wolfkillj (9/25/2013)

    The only problem with that setup for a recoilless design is that it would slice the deployable fins off, too. I don't think that anything less than...

    September 25, 2013 at 8:56 am

    #1653216

  • RE: Are the posted questions getting worse?

    Chad Crawford (9/25/2013)

    The Dixie Flatline (9/24/2013)

    I haven't launched an Estes rocket in almost 40 years, but why stop at potatoes? It strikes me that carrots would...

    September 25, 2013 at 8:39 am

    #1653204

  • RE: CTE

    Jamsheer (9/24/2013)

    ** CTE is a 'reference' to the source tables. i.e. Any changes to CTE will affect the Source table.

    Actually, this is not quite correct. Yes, CTEs are nothing...

    September 25, 2013 at 7:41 am

    #1653154

  • RE: CTE

    Carlo Romagnano (9/25/2013)

    CTE is usefull only in recursive query for tally table:

    Then presumably all language features that provide simplified expressions to replace complexity are useless, in your opinion? If...

    September 25, 2013 at 5:20 am

    #1653067

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/23/2013)

    dwain.c (9/23/2013)

    I'm more interested in the specs on your rail gun pork chop launcher. 😛

    BWAA-HAAA!!!! Sorry... that would be proprietary information. So are the Nitrogen tri-Iodide powered...

    September 24, 2013 at 7:00 pm

    #1652931

  • RE: Dynamic Query

    Hugo Kornelis (9/24/2013)

    L' Eomot Inversé (9/24/2013)

    Interesting question.

    I knew the answer, but Jens-Peter's comment made me wonder: he's quite right, the behavious is not documented on the page referenced. Nor...

    September 24, 2013 at 6:31 pm

    #1652929

  • RE: Dynamic Query

    Interesting question.

    I knew the answer, but Jens-Peter's comment made me wonder: he's quite right, the behavious is not documented on the page referenced. Nor is it documented on the...

    September 24, 2013 at 3:23 pm

    #1652901

  • RE: Are the posted questions getting worse?

    GilaMonster (9/23/2013)

    And now that the paperwork has been signed....

    November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on...

    September 23, 2013 at 4:28 pm

    #1652507

  • RE: 108,000,000 row table - check for matches

    bleroy (9/23/2013)

    What about adding 1 column to the small table that would contain RIGHT(smallTable.toid,13), create an index on that and then do your join?

    B

    I wish I'd said it in those...

    September 23, 2013 at 11:33 am

    #1652416

  • RE: 108,000,000 row table - check for matches

    duncanburtenshaw (9/23/2013)

    Erland Sommarskog (9/21/2013)

    Before we start talking about sargable arguments, maybe we should see if there is anything to sarg for. From what Duncan says, there does not seem to...

    September 23, 2013 at 6:36 am

    #1652312

  • RE: How to insert in 3 tables using stored procedure

    AndrewSQLDBA (9/20/2013)

    This code is a waste, since @FirstName is an input parameter that will not allow a NULL. And the front-end should be checking the values for blanks, not the...

    September 21, 2013 at 10:48 am

    #1652144

  • RE: 108,000,000 row table - check for matches

    The thing to do is try to avoid the scan of the big table; give it something simple to look for.

    I don't offer any guarantee, but something like this...

    September 21, 2013 at 10:08 am

    #1652139

Viewing 15 posts - 3,046 through 3,060 (of 7,484 total)