Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 7,484 total)

  • RE: Today's Random Word!

    Revenant (4/4/2014)

    SQLRNNR (4/4/2014)

    mishka

    Grishka

    Shishka

    April 4, 2014 at 3:39 pm

    #1703448

  • RE: A Questionable Trigger

    Hugo Kornelis (4/4/2014)

    TomThomson (4/3/2014)

    I think maybe I'm reverting to terminology that has changed since I learnt it, I have a feeling that when I first saw the term "heap" it...

    April 4, 2014 at 3:29 pm

    #1703447

  • RE: Are the posted questions getting worse?

    Sean Lange (4/4/2014)

    Greg Edwards-268690 (4/4/2014)

    SQLRNNR (4/4/2014)

    Sean Lange (4/4/2014)

    I usually limit the list to two choices: "right" or "right now".

    Good solid choices. Tough call. Eeny meeny miney mo!

    Right...

    April 4, 2014 at 3:20 pm

    #1703443

  • RE: TABLESAMPLE output

    Just tosupplement what Hugo wote: the reason for working at page level insteadof at row level is performance. Think of a moderate sized table, say a million rows spread...

    April 4, 2014 at 2:00 pm

    #1703420

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/3/2014)

    TomThomson (4/3/2014)

    You can have it fast, cheap, or right - pick only one of the three.

    I thought that was 2 of 3? When did this change? ...

    April 3, 2014 at 8:04 pm

    #1703168

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/3/2014)

    Revenant (4/3/2014)

    Sean Lange (4/3/2014)

    Greg Edwards-268690 (4/3/2014)

    it was clear they had no idea what they wanted or needed.

    But finish it by Friday.

    This is an everyday occurrence...

    April 3, 2014 at 7:38 pm

    #1703165

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/3/2014)

    When Marketing meets with Engineering, nothing is impossible. 😀

    Reminds me of a meeting where the business wanted something built, but when you started asking some questions, it...

    April 3, 2014 at 4:44 pm

    #1703136

  • RE: A Questionable Trigger

    Hugo Kornelis (4/3/2014)

    TomThomson (4/3/2014)

    You see an index seek on a heap? Good heavens, has the worl changed totally while i wasn't looking?

    This has been possible since at least SQL...

    April 3, 2014 at 4:09 pm

    #1703125

  • RE: TABLESAMPLE output

    pmadhavapeddi22 (4/3/2014)

    when we are specifying high range of rows nearing to the exact no of rows then it will return all the rows of the table

    like , in the QOD

    we...

    April 3, 2014 at 3:13 pm

    #1703109

  • RE: A Questionable Trigger

    auke.teeninga (4/3/2014)

    Sean Lange (4/3/2014)

    While that does meet some esoteric requirements this will perform very poorly because this is nonSARGable.

    Good call on the bit field. I try to avoid them myself,...

    April 3, 2014 at 3:03 pm

    #1703106

  • RE: A Questionable Trigger

    Sean Lange (4/3/2014)

    auke.teeninga (4/3/2014)

    I think the trigger still contains a logic error...

    Currently it updates the datechanged even if the values remain the same. Maybe if the field was called DateUpdated...

    April 3, 2014 at 2:58 pm

    #1703104

  • RE: A Questionable Trigger

    Hugo Kornelis (4/2/2014)

    I understand that, after running into this, Andy wanted to submit this as a QotD. But he somehow forgot to check exectly how unrealistic the assumptions are that...

    April 3, 2014 at 2:54 pm

    #1703102

  • RE: Can't See The Forest For the Logins

    Hugo Kornelis (3/31/2014)

    My view (yours may vary) is to always use master as the default and always make developers specify the database in their connection strings.

    Yes, my view varies.

    I prefer...

    April 3, 2014 at 1:24 pm

    #1703063

  • RE: Can't See The Forest For the Logins

    paul.knibbs (3/28/2014)

    I read the word "hardened" and still got it wrong, probably because "hardened" is such a nebulous term--I had no idea what it meant with relation to SQL server....

    April 3, 2014 at 12:52 pm

    #1703035

  • RE: X in Technology

    As you guys seem to have an aversion to the quotation tabs, I'm not sure who said what.

    Goofy, please understand that the concept of socioeconomic status has been around for...

    April 1, 2014 at 7:02 pm

    #1702298

Viewing 15 posts - 2,626 through 2,640 (of 7,484 total)