Post reply

Error messages

  • January 11, 2015 at 10:14 pm

    #1769395

    Reminds me of a question I once saw on a non-MS exam...

    Which of the following Recovery Models will allow for minimally logged index rebuilds?

    A. Bulk Logged

    B. Bulk-Logged

    C. Bulk_Logged

    D. BulkLogged

    😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • January 12, 2015 at 7:01 am

    #1769487

    Thanks for the question.

  • January 12, 2015 at 7:32 am

    #1769499

    Jeff Moden (1/11/2015)

    Reminds me of a question I once saw on a non-MS exam...

    Which of the following Recovery Models will allow for minimally logged index rebuilds?

    A. Bulk Logged

    B. Bulk-Logged

    C. Bulk_Logged

    D. BulkLogged

    😛

    They must want someone who knows things by the book instead of someone someone who knows the technology by using it. :sick:

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • January 12, 2015 at 10:28 am

    #1769575

    Jeff Moden (1/11/2015)

    Reminds me of a question I once saw on a non-MS exam...

    Which of the following Recovery Models will allow for minimally logged index rebuilds?

    A. Bulk Logged

    B. Bulk-Logged

    C. Bulk_Logged

    D. BulkLogged

    😛

    The answer to that question is, obviously: "Yes".

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • January 12, 2015 at 11:16 am

    #1769587

    Ed Wagner (1/12/2015)

    They must want someone who knows things by the book instead of someone someone who knows the technology by using it. :sick:

    That's why I have a huge problem with certification exams. They don't require one to UNDERSTAND the problem but merely to be able to repeat what the documentation states.

    I knew a guy once who was a 4.0 student in accounting. I, on the other hand, took no accounting classes whatsoever yet I understood the basics of the debit/credit issue better than he did. He aced the exams because of his eidetic (photographic) memory and could regurgitate what the books stated quite well but he didn't understand the subject.

    I am quite the opposite in that I usually don't do well on exams because I don't recall specific details exactly whereas I do much better on application. I had a college professor tell me once that if you use something often enough you'll remember it and if not you can always look it up but you still have to understand how to apply that information to the problem to achieve the solution.

    LinkedIn: http://www.linkedin.com/in/sqlrv
    Twitter: http://www.twitter.com/sqlrv
    Website: http://sqlrv.com

  • January 12, 2015 at 11:59 am

    #1769600

    Ed Wagner (1/12/2015)

    Jeff Moden (1/11/2015)

    Reminds me of a question I once saw on a non-MS exam...

    Which of the following Recovery Models will allow for minimally logged index rebuilds?

    A. Bulk Logged

    B. Bulk-Logged

    C. Bulk_Logged

    D. BulkLogged

    😛

    They must want someone who knows things by the book instead of someone someone who knows the technology by using it. :sick:

    My point exactly. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • January 12, 2015 at 12:03 pm

    #1769602

    Aaron N. Cutshall (1/12/2015)[hrThat's why I have a huge problem with certification exams. They don't require one to UNDERSTAND the problem but merely to be able to repeat what the documentation states.

    Except for the MCM certification, I have to say that's pretty much the feelings I have for certs.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply