Error messages

Question

Post reply

Error messages

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

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

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 1

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)

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

akljfhnlaflkj

SSC Guru

Points: 76202

January 12, 2015 at 7:01 am

#1769487

Thanks for the question.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

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/

Aaron N. Cutshall SSCrazy Eights Points: 9014 More actions · Answer 5

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: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 6

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)

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 7

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)