Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 7,483 total)

  • RE: Are the posted questions getting worse?

    capnhector (9/21/2012)


    ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit Godwin's law?

    Yes, Craig mentioned a certain person (naughty...

  • RE: Design pattern for Phone

    Luis Cazares (8/24/2012)


    The design relies on many things and the most common (and correct) answer is "it depends".

    That seems to me to be the most anyone could say without...

  • RE: Today's Random Word!

    Cliff Jones (9/20/2012)


    SQLRNNR (9/20/2012)


    Nelly

    deli

    belly

  • RE: GO Part 2

    lanre_makinde (9/19/2012)


    Sorry the explanation is wrong. Then the question is not properly framed. Questions should be aimed at eliciting understanding....

    It appears to me to be right, to...

  • RE: Tablesample

    Hugo Kornelis (9/19/2012)


    Miles Neale (9/19/2012)


    Kind of erodes the confidence in certain uses of the product.

    Huh? Why?

    SELECT TOP ... without ORDER BY is like saying "give me the first by any...

  • RE: odd data design (at least to me)

    patrickmcginnis59 (9/19/2012)


    I've seen product tables like that. One advantage to them I see is that the organization using this can enter product attributes and values for those attributes without having...

  • RE: Are the posted questions getting worse?

    dwain.c (9/18/2012)


    L' Eomot Inversé (9/18/2012)


    Evil Kraig F (9/18/2012)


    Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.

    No, it doesn't....

  • RE: Tablesample

    I got it wrong. I looked at it, and realised that there are in theory 3 correct answers there: the table will always return no more than 1 row,...

  • RE: Are the posted questions getting worse?

    Evil Kraig F (9/18/2012)


    Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.

    No, it doesn't. If I understand...

  • RE: odd data design (at least to me)

    dglane (9/18/2012)


    What a coincidence. In a thread below that I read, I learned that this may be the EAV model.

    It does indeed look like a variant of EAV -...

  • RE: FILTER

    Nice easy question.

    I'm sure I selected 6, but the system told me I was wrong. I guess I didn't select what I though selected - senility setting in,...

  • RE: Searching the time data type

    GSquared (9/17/2012)


    L' Eomot Inversé (9/15/2012)


    Unless there is some performance issue that I haven't spotted, it should be sensible to do this the simple and obvious way:

    SELECT LoadNumber

    FROM...

  • RE: Backups

    Good question.

    But the referenced BoL page doesn't describe this behaviour, the problem isn't that a media set can't contain both compressed and uncompressed backups (if both backups worked in the...

  • RE: UPDATE when the values are the same

    Sergiy (9/16/2012)


    L' Eomot Inversé (9/16/2012)


    ... the storage engine decides not to update the row

    Can you please provide a reference to a document saying that storage engine operates rows?

    So far...

  • RE: UPDATE when the values are the same

    Sergiy (9/16/2012)


    Trigger is executed after UPDATE. If SQL Server figures out that the values are the same and does not proceed with writing to the pages then trigger has no...

Viewing 15 posts - 4,141 through 4,155 (of 7,483 total)