Forum Replies Created

Viewing 15 posts - 3,616 through 3,630 (of 7,484 total)

  • RE: LEN()

    Thomas Abraham (3/29/2013)

    Nice question, on a seemingly simple, but not so, issue. Thanks!

    Nice question.

    It's surprising that nearly 40% (80 out of 203) answers are wrong. Some of that is...

    March 29, 2013 at 6:35 am

    #1601985

  • RE: Are the posted questions getting worse?

    WayneS (3/28/2013)

    Lowell (3/28/2013)

    BrainDonor (3/28/2013)

    Lynn Pettis (3/27/2013)

    What to make of this?

    May not be what I was thinking. Good.

    "I'm a DBA, it turns out"

    How do you suddenly discover that you're a...

    March 28, 2013 at 11:35 am

    #1601768

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/28/2013)

    L' Eomot Inversé (3/28/2013)

    BrainDonor (3/28/2013)

    Lynn Pettis (3/27/2013)

    What to make of this?

    May not be what I was thinking. Good.

    "I'm a DBA, it turns out"

    How do you suddenly discover...

    March 28, 2013 at 8:58 am

    #1601677

  • RE: Are the posted questions getting worse?

    GilaMonster (3/28/2013)

    Welcome to Books Online. I personally love the sections that are completely, blatantly wrong.

    I prefer the sections that mix wrong and right, especially the ones that directly contradict themselves....

    March 28, 2013 at 8:54 am

    #1601670

  • RE: Are the posted questions getting worse?

    BrainDonor (3/28/2013)

    Lynn Pettis (3/27/2013)

    What to make of this?

    May not be what I was thinking. Good.

    "I'm a DBA, it turns out"

    How do you suddenly discover that you're a DBA?

    Don't most...

    March 28, 2013 at 8:49 am

    #1601663

  • RE: Truncate Table

    Nice straightforward question.

    March 28, 2013 at 4:31 am

    #1601537

  • RE: Database Mirroring

    Hugo Kornelis (3/27/2013)

    L' Eomot Inversé (3/27/2013)

    Evgeny Garaev (3/26/2013)

    Correction, Principal do not wait for commit transaction on the mirror. It waits for transaction being recorded in transaction log file on the...

    March 27, 2013 at 10:10 am

    #1601242

  • RE: Database Mirroring

    Nice question; I got it wrong - expected to choose between two (asynchronous and synchronous plus maybe some red herrings) when I read the question but then saw the three...

    March 27, 2013 at 6:52 am

    #1601118

  • RE: CASCADE - 2

    Hugo Kornelis (3/26/2013)

    I think you're reading a bit too much into the code used to create some sample data, Tom. I suspect ROn used this method to eaily visualize which...

    March 26, 2013 at 12:27 pm

    #1600936

  • RE: CASCADE - 2

    kevin.l.williams (3/26/2013)

    L' Eomot Inversé (3/26/2013)

    And intensly I dislike the horrible violation of 1NF - code examples like this risk teaching really awful habits to inexperienced people who see them.

    I'm very...

    March 26, 2013 at 7:54 am

    #1600797

  • RE: CASCADE - 2

    Apart from the messed up wording of the answer options this is a good question.

    It would have been a better question if more care had been taken with editing the...

    March 26, 2013 at 5:52 am

    #1600731

  • RE: Passing Tables as Parameters

    dwain.c (3/24/2013)

    Danny, Ron and Tom - Thanks to all for giving it a go.

    The history of this was that I was playing around with passing subqueries to TVFs, hoping for...

    March 25, 2013 at 10:13 am

    #1600390

  • RE: Passing Tables as Parameters

    Nice question.

    But does the fourth batch fail with an error or with two errors? Anyone, I find it surprising that the two error messages give the same line number,...

    March 24, 2013 at 5:26 am

    #1600106

  • RE: Are the posted questions getting worse?

    Evil Kraig F (3/21/2013)

    I can't speak for the UK but a single bad reference can kill a contracting career.

    There are two problems in the UK: (i) it's...

    March 22, 2013 at 4:32 pm

    #1600008

  • RE: Delete v Truncate

    Toreador (3/22/2013)

    On reflection - given that you cannot use truncate on a table referenced by foreign keys - it seems more like it is actually doing a drop/create. Which would...

    March 22, 2013 at 11:27 am

    #1599912

Viewing 15 posts - 3,616 through 3,630 (of 7,484 total)