Forum Replies Created

Viewing 15 posts - 406 through 420 (of 658 total)

  • RE: SQL Server Agent Proxies

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


    got it right by common sense reasoning, not by random guessing.

    My common sense reasoning (followed by a random guess) was that there are plenty of other places...

  • RE: SYSLanguages on SQL 2012

    I knew the answer, but if I hadn't then a reasonable guess would have been that it would work - on the basis that it makes sense to have a...

  • RE: SQL Server Agent Proxies

    Stewart "Arturius" Campbell (5/15/2012)


    what is disturbing is how many (45% at this point in time) of responders selected "yes".

    Why is that disturbing? It's not as if it's important to know...

  • RE: String comparison

    L' Eomot Inversé (5/9/2012)It would have been somewhat shocking if I had got this one wrong after writing the 15th April 2010 QotD 😛

    I thought the subject seemed familiar!

  • RE: DateTime Puzzle

    To those who said the answer was easy - is this because you know how SQL handles implicit conversions of this sort, or because you ran the code? I didn't...

  • RE: Sequences III

    Does anyone have any suggestions for possible uses for sequences? Once upon a time I'd have used them for populating primary keys instead of using identities (ie the way I...

  • RE: SP

    Ah. That's different...

  • RE: SP

    Edit: The following is mainly nonsense, but I've left it in so that subsequent replies make sense 🙂

    some harsh responses IMHO. Who knows whether the author made use of a...

  • RE: Altering a Column

    KWymore (4/25/2012)


    I have no issue not being told how many answers to choose.

    My only issue is that since we're nortmally told when more than one answer is needed, I...

  • RE: Altering a Column

    codebyo (4/25/2012)


    Sorry, guys, for not adding a note on how many answers should be selected.

    Steve always used to do this (or something in the QotD publishing widget did it automatically).

  • RE: Altering a Column

    Steve's presumably got rid of the code that automatically told you how many options to choose on a multi-select question 🙁

  • RE: Sequences II

    Thomas Abraham (4/24/2012)


    this feature behaves as you would design it.

    Which is the reason I guessed wrong 😉

  • RE: Bulk Logged recovery model

    I guessed right, on the basis that if the answer was No then it wouldn't be a very interesting question 🙂

    It then prompted me to read up a bit on...

  • RE: SELECT options

    Interesting! Also

    select Top 5 with ties *

    from TopTest

    order by SomeValue desc

    Seems like in this case, NULL = NULL

  • RE: SELECT options

    Daniel Bowlin (4/13/2012)Then I thought when right clicking on a table and choosing "Select Top 1000 Rows" there are no () surrounding the number.

    So there aren't. How very Microsoft!

Viewing 15 posts - 406 through 420 (of 658 total)