Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/30/2013)


    wolfkillj (12/30/2013)


    Stefan Krzywicki (12/30/2013)


    wolfkillj (12/30/2013)


    GilaMonster (12/30/2013)


    wolfkillj (12/30/2013)


    is there really a performance problem or are you just "tuning" the query as a knee-jerk response to seeing a scan in...

  • RE: Memory-optimized table indexes in SQL 2014

    Dr. Diana Dee (12/29/2013)


    Tom - What is the "hardware cache line length"? Do you know of a reference I can read about that?

    Thanks

    Diana

    I can't think of any references to...

  • RE: Today's Random Word!

    BWFC (12/30/2013)


    L' Eomot Inversé (12/29/2013)


    eccentricDBA (12/27/2013)


    Curiae Regis

    Areopagus Basiléou

    Not for the first, and certainly not for the last time on this site, I'm going to have to show my ignorance. ...

  • RE: New Year's Eve

    Nice question.

    I spent some time wondering whether the second option was really intended to have that "b" or not, but decided that as it would also need other changes to...

  • RE: Memory-optimized table indexes in SQL 2014

    Nice question. I found that thinking about it led me into all sorts of side tracks (which didn't stop after I'd reached an answer) some of which leave me...

  • RE: Memory-optimized table indexes in SQL 2014

    Nice question. I found that thinking about it led me into all sorts of side tracks (which didn't stop after I'd reached an answer) some of which leave me...

  • RE: predict the output

    Good question.

    The delete in the second case almost made me get it wrong, because deleting all the rows doesn't have the same effect as truncating the table of never inserting...

  • RE: Are the posted questions getting worse?

    EL Jerry (12/27/2013)


    Tom,

    Where were those pictures taken?

    The ones I posted about a week ago? In my garden, in Puerto del Carmen - that's 28°55'22,5?N 13°40'01,7?W, roughly. 🙂

  • RE: Today's Random Word!

    eccentricDBA (12/27/2013)


    Curiae Regis

    Areopagus Basiléou

  • RE: Today's Random Word!

    Revenant (12/27/2013)


    SQLRNNR (12/27/2013)


    hive

    Registry

    Registrar

  • RE: Santa's Reindeer

    Good question.

    Of course if you had included 5 and 6 in the answer options it wouldn't have been.

  • RE: Execution Plan Cursors

    I agree with Hugo here. But unlike him I thought the question wasn't worth doing any serious research on, so I didn't spot that "snapshot" had some reference to...

  • RE: All the rows before this one

    Steve Jones - SSC Editor (12/20/2013)


    You would use unbounded preceding for all the rows. The title did say all the rows, but the question did not.

    Steve, that's special pleading. ...

  • RE: Page Repair

    Dana Medley (12/19/2013)


    Great question Steve. I had it right to begin with, then I second guessed myself. Should've stuck with my original answer.

    That's exactly where I went wrong - changed...

  • RE: Central Management Servers

    Good question.

    Given that this limitation is easily evaded, as a couple of comments have pointed out, I agree that it is a drawback as suggested in teh explanation, because it...

Viewing 15 posts - 2,806 through 2,820 (of 7,484 total)