Forum Replies Created

Viewing 15 posts - 61 through 75 (of 92 total)

  • RE: Combining union and union all

    Thanks for the question - and once again great discussion afterwards - learnt from that!

  • RE: Not In

    thanks for the question, and as usual the more interesting discussion that follows. 😀

  • RE: Arithmetic 1

    Very interesting question. Learnt something new again.

  • RE: SQL Server Agent Roles

    Nice Easy question - thanks.

  • RE: Object_Id 1

    Thanks for the easy question - nice to check the basics again.

  • RE: Model Database

    Interesting question, and based on the comments here, I take it there is (and still for me) a lot of confusion.

    If you rely on Books Online / MSDN and...

  • RE: MERGE

    Great question! As with most people didn't think of all the limitations and was very annoyed when I got it wrong - with myself.

  • RE: HASHBYTES

    Have to agree that the SALE string confused me too. Otherwise it was a fairly simple question - Thanks

  • RE: INSERT OUTPUT

    Nice simple basis question - Thanks! I did have to double check looking for the trick though!!!

  • RE: Clustered Instances

    Great question and quite thought provoking. Had to dig around a bit to find that one.

    Definitely learnt something new through the question

  • RE: Collation and SQL_VARIANT

    Great question, I have definitely learnt something today! Whether I ever use it will be another question!!! 🙂

    Thanks

  • RE: Spatial Data Types

    Ola L Martins-329921 (10/26/2011)


    It's a good question - I didn't know these new types!

    But, the answers rule out themselves - you actually cannot get this one wrong with logical deduction:

    If...

  • RE: Use of BETWEEN and DATETIME

    Thanks for the question - I have to agree though, that the effort in the question seems more set to trick than to test actual knowledge.

    Guess it makes one double...

  • RE: INSERT INTO

    I agree with what the question was trying to show, however I believe the answers were wrong for the following reason (and you could select 4). Both inserts will generate...

  • RE: Disaster Recovery

    Nice easy question - particularly since you mention pick 2! I think had you left that off, it would have been a bit more interesting to see how many options...

Viewing 15 posts - 61 through 75 (of 92 total)