Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 7,484 total)

  • RE: Five percent rounded down

    jfgoude (1/10/2013)

    I think no one could guess correct answer without copying it into sql edit view.

    so I can say surely there is 63% cheaters

    Even if people were just making random...

    January 11, 2013 at 5:41 am

    #1576221

  • RE: UNIQUE constraint

    Christian Buettner-167247 (1/11/2013)

    Oh my, why is this question still wrong in January?!? 🙁

    That's a good question. These days it seems usual that something this bad is corrected quite quickly....

    January 11, 2013 at 5:11 am

    #1576203

  • RE: Today's Random Word!

    SQLRNNR (1/10/2013)

    bitters

    Angostura or English beers?

    January 10, 2013 at 11:15 am

    #1575907

  • RE: Coalesce and Conversion

    john.arnott (1/8/2013)

    How annoying. You made me think! 😉

    I agree this was an excellent question and explanation. I do see that one minor correction could be needed...

    January 10, 2013 at 10:47 am

    #1575898

  • RE: RANK - 1

    Hugo Kornelis (1/7/2013)

    Tom, AdventureWorks is available in different flavors. Apparently, you downloaded and installed the case sensitive version, but there is a case insensitive version as well.

    I think the question...

    January 7, 2013 at 12:55 pm

    #1574495

  • RE: RANK - 1

    This would have been a good question and easy to get right if the schemaname had been spelt "Sales" instead of "SALES". However, I happened to remember that the...

    January 7, 2013 at 9:59 am

    #1574407

  • RE: T-SQL

    Toreador (1/4/2013)

    I don't really like this question.

    "They are not the same, but they both enforce uniqueness of the column on which they are defined"

    assumes that they can both only...

    January 5, 2013 at 9:40 am

    #1574051

  • RE: T-SQL

    Lynn Pettis (1/4/2013)

    However, each pair is unique and attempting to enter a duplicate will fail.

    Yes, of course attempting to insert a duplicate will fail, that's the whole point of a...

    January 5, 2013 at 9:22 am

    #1574049

  • RE: T-SQL

    Dineshbabu (1/3/2013)

    I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that will allow more...

    January 4, 2013 at 8:49 am

    #1573792

  • RE: T-SQL

    SQLRNNR (1/3/2013)

    I have to disagree with the correct answer(s). The question asks for 4 correct answers yet 5 are presented. This causes a bit of a guessing game.

    I...

    January 4, 2013 at 8:33 am

    #1573779

  • RE: New Year's Math

    Nice question. I enjoyed it.

    The "flying duck" code layout made it easy to check that the parentheses matched up, so could see easily that there was no syntax error...

    January 3, 2013 at 6:15 pm

    #1573540

  • RE: Finding New Years Eve

    Hugo Kornelis (1/2/2013)

    john.arnott (1/2/2013)

    Hugo,

    Just testing to see if we're reading carefully? 😉

    Looks as though your option 2 is screwed up somehow, returning dates years off.

    SELECT dateadd(month, datediff(month, getdate(),...

    January 2, 2013 at 8:26 pm

    #1573149

  • RE: Storage Subsystems and RAMDisks

    kevin.kembel (1/2/2013)

    The consensus by everyone so far in this thread definitely seems to be that table variables and temp tables work in RAM when available, and only spill to disk...

    January 2, 2013 at 8:05 pm

    #1573148

  • RE: Are the posted questions getting worse?

    GSquared (1/2/2013)

    Anyone with better data than I have on temp tables vs table variables, wanna take a look at this one: http://www.sqlservercentral.com/Forums/Topic1399050-377-1.aspx?

    Gail, I linked two of your SQL In the...

    January 2, 2013 at 2:23 pm

    #1573087

  • RE: Storage Subsystems and RAMDisks

    kevin.kembel (1/2/2013)

    I've look at Google and your links, and it still appears to me that what you said before isn't entirely correct - which is why I was hoping for...

    January 2, 2013 at 2:21 pm

    #1573084

Viewing 15 posts - 3,841 through 3,855 (of 7,484 total)