Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 7,483 total)

  • RE: Are the posted questions getting worse?

    duplicate - deleted.

    Tom

    December 1, 2014 at 9:06 am

    #1761765

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/30/2014)

    There also has to be a good mechanism for blocking posts that doesn't drag down the site's performance. I think that poor performance is worse than lots...

    Tom

    December 1, 2014 at 9:03 am

    #1761762

  • RE: Are the posted questions getting worse?

    Divine Flame (11/26/2014)

    Voted. 153 now.

    Now 167.

    Needs quite a few more vote, I think.

    Tom

    November 28, 2014 at 4:52 am

    #1761414

  • RE: Please vote for the "built in Tally Table" function.

    voted.

    It's now 167. Not growing fast enough.

    Tom

    November 28, 2014 at 4:51 am

    #1761413

  • RE: Find the Most Recent Post

    marcia.j.wilson (11/24/2014)

    TomThomson (11/24/2014)

    Nice question, but I have two queries about it:

    (i) why 2 points? it's just extremely simple logic.

    (ii) why use first_value and DESC when last_value would do, so...

    Tom

    November 28, 2014 at 4:30 am

    #1761409

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    TheSQLGuru (11/23/2014)

    TomThomson (9/25/2014)

    sfrostx (9/25/2014)

    Can anyone help me understand why the second and third selects in the following generate an error?

    I don't understand it at all. An interesting twist is...

    Tom

    November 28, 2014 at 3:34 am

    #1761396

  • RE: Azure

    Easy question.

    Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database that...

    Tom

    November 28, 2014 at 3:12 am

    #1761395

  • RE: Thanksgiving 2014

    antony-688446 (11/27/2014)

    Well, I learnt something today. When Thanksgiving is 🙂

    I thought everyone knew it was teh day when 2 turkeys got preseidential pardons.

    Tom

    November 27, 2014 at 2:29 pm

    #1761349

  • RE: In The Beginning

    Kev T (11/25/2014)

    Thanks Paul, how interesting! I wonder how this is handled in Greece with regards to big data and historical records, or if they forgone the lost days...

    Tom

    November 26, 2014 at 7:45 am

    #1761092

  • RE: In The Beginning

    Carlo Romagnano (11/25/2014)

    Extremely easy!

    Thanks!

    But more than half the answers so far were wrong! (Probably because people forgot about negative integers, I guess.)

    Tom

    November 26, 2014 at 7:16 am

    #1761081

  • RE: IF EXISTS vs @@ROWCOUNT

    Hugo Kornelis (11/26/2014)

    Sorry for the harsh words, but this is absolute rubbish.

    The code in option 2 will always do two lookups. One for the EXISTS, and then another one for...

    Tom

    November 26, 2014 at 7:06 am

    #1761079

  • RE: Find the Most Recent Post

    Nice question, but I have two queries about it:

    (i) why 2 points? it's just extremely simple logic.

    (ii) why use first_value and DESC when last_value would do, so that the...

    Tom

    November 24, 2014 at 4:02 am

    #1760457

  • RE: Find the Most Recent Post

    edwardwill (11/24/2014)

    The question asked:

    Which of the following will return only the Id of the most recent post for each Author?

    The correct answer should have been "None of the above",...

    Tom

    November 24, 2014 at 3:59 am

    #1760455

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/22/2014)

    Edit: Oh yeah, of the 3 pages of "posts added today" there was only one non-spam post.

    I must be lucky, I can see twice as many non-spam...

    Tom

    November 23, 2014 at 10:01 am

    #1760382

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/22/2014)

    Jeff Moden (11/22/2014)

    David Burrows (11/21/2014)

    Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀

    Heh... I've reached the "Overflow Exception" a couple...

    Tom

    November 22, 2014 at 2:38 am

    #1760320

Viewing 15 posts - 2,056 through 2,070 (of 7,483 total)